Pivot Table - Showing GRAND TOTAL in COLUMN on RIGHT SIDE PIVOT TABLE

[rish1]

Hi All

I have created a table where i add all the data, and also created a pivot table.

https://we.tl/aUm1XK7Eoa

i am trying to get a GRAND TOTAL on the right side of the pivot table showing the GRAND TOTAL....tried many of things, but no joy...

Any help would be much appreciated.

Many Thanks

 

[Oaktree]

The way to sum across different fields in a pivot table is to add a calculated field. Click on your pivot table, go to Analyze --> Fields, Items, and Sets --> Calculated Field. Name your new field "My Grand Total" and set its formula to =Normal + ISA + Divi

 

[rish1]

Hi Oaktree...

It worked...

Superstar!

Thanks Have a great day