Skip to main content

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!

Here is a display of the current pivot table.

 


HI @Del 

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

 


Reply