Good Afternoon,
I am creating a lovely pivot table but cannot for the life of me figure out how to total it at the bottom, like this:
I am sure it's on the "hidden menu", you know like how you can order an In & Out Burger protein style (no bun), but it's not on the menu.
Thanks for any insight.
If you click the three horizontal lines of your first Row element there should be an option for Grand Totals. Does that help?
Hi Kimberly!
If you right click on one of the headers, it will give you this screen:
From there, just choose grand totals, and that should work for you. :)
You are BRILLIANT. MUAH!!!!!!!