Pivot tables

Hi Anka,

Thank you for the forum question.

This is not an option in a "normal" PivotTable without doing the calculation in the source data. If the PivotTable is created from a data model in Excel (PowerPivot) we have DAX measures which can give us this information.

I hope this is helpful.

Kind regards

Jens Bonde
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