Unhide pivot table grand total column

[kshines]

Hello,

I found a tip on Mr Excel that has been great however I need to reverse the process.
"You could change the font colour to white for that grand total. The
column will appear empty, and the results will stay hidden, even if you
pivot the data in the table."

Can anyone please help me on how to return the Grand Total to showing? I have tried to select the cell and set to black but that doesn't work

Thank you very much in advance!

KH

 

[cyrilbrd]

Click on the Pivot table
Select the Design tab
Look at Layout.
Grand Total
Select On for Column if you want in below the table or On for Rows if you want it on the far right of the table.

 

[kshines]

Thank you so very much!!! that worked perfectly. It's always something simple.
KH

 

[cyrilbrd]

You are most welcome, thanks for your feedback.

 

[cyrilbrd]

...
"You could change the font colour to white for that grand total. The
column will appear empty, and the results will stay hidden, even if you
pivot the data in the table."
...

Just a parenthesis:
That was not a very sound advice.
You can just hide whatever you do not need from the layout portion, including subtotals.
Or you can hide unwanted Rows or Columns or data from the filters.