Pivot table , variant YOY, sort, decending order, chart

Hi David,

Thank you for the forum question.

I do not know if you use

Show values as -> Difference From

to get your YOY. If you then try to sort YOY Ascending or descending you get the error below.


"AutoSort and AutoShow cannot be used with custom calculations that use the positional references. Do you want to turn off AutoSort/Show?"

If you click yes to the question in the error above nothing will happen. The link below can help you turn off Auto sort.

https://www.experts-exchange.com/questions/28324629/Sorting-Excel-pivot-table.html

I am not sure without having the PivotTable in front of me if this will do the job. I am afraid that you will have to calculate YOY in a column in the source data to be able to do what you want.

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