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!
