Pivot

Hi Rika,

Thank you for the forum question.

Do you mean that you will compare year with previous year?

Then you have to add the values you want to compare twice under values in the PivotTable and add the years to Rows. Right click on one of the values in the second column of values on the PivotTable and click "Show values as" and select % Difference from. The Base field must be Years and base item must be Previous.

I hope this makes sense.




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