Skip to main content
Solved

Hide row in a pivot table


Forum|alt.badge.img
  • Freshman I
  • 42 replies

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?

 

View original
Did this topic help you find an answer to your question?

2 replies

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

Here is a display of the current pivot table.

 


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2152 replies
  • 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?

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings