Pivot tables - calculated field totals

Hi Hilary

Thanks for getting in touch. This is a common quirk of the PivotTable: the Grand Total is not a total of the fields above, but a further Calculated Field.

Try this: sum all of your first field, then sum all of your second field. Multiply these answers together and you will get what the Grand Total is reporting.

I hope this explains the confusion.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector