Get instant live expert help on How do I show grand total in pivot chart

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I want to setup my pviot to auto-calculate to view difference in Pivot Table vs. Grand Total. Difference in sum of quantity instead of grand total.
Solved by Z. C. in 24 mins
Sort by Pivot Table Row Grand Total column
Solved by I. E. in 18 mins
I created a calculated field in my pivot table to show % difference in sales from year to year. It works fine except in the grand total column. it shoes #DIV/O!
Solved by Z. L. in 25 mins
I have a formula that returns grand total value from pivot table but would like it tweaked so that if grand total value is blank, then return text else return another text
Solved by F. A. in 11 mins
How do I place a subtotal and grand total at the top of the pivot table?
Solved by V. U. in 18 mins