Skip to main content
Answer

Hide row in a pivot table

  • June 11, 2024
  • 2 replies
  • 56 views

Forum|alt.badge.img

I have  a pivot table that shows the number of orders shipped Last Year vs This Years.

I have a column called Month, and another called MonthName. I have the Month column so that the pivot table will show the months in the correct order. I want the MonthName column because it make the pivot table easier to read. 

Is there a way to “hide” the month column but still use it as the sort for the pivot table?

Thank you!

Best answer by Kandy Beatty

HI @Del 

When you say “hide” do you mean remove it? Why not just click the minus sign on the row?

 

2 replies

Forum|alt.badge.img
  • Author
  • Freshman I
  • June 11, 2024

Here is a display of the current pivot table.

 


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • Answer
  • June 11, 2024

HI @Del 

When you say “hide” do you mean remove it? Why not just click the minus sign on the row?