Pivot Table Filter On "Difference From"

[blimbert]

Hello, I cannot figure how to use a pivot table to filter a pivot table by the largest or smallest "difference from" the prior year. The use setting is to see only the top 10 growth or loss versus the previous year.

My sample dataset is as follows:

Year	Region	Amount
2020	1	100
2019	1	90
2018	1	80
2020	2	80
2019	2	90
2018	2	100
2020	3	100
2019	3	100
2018	3	100

My pivot table calculates the Difference From Amount, using the Previous Year. the result looks like this:

What I am trying to accomplish is to filter that Difference From to show things like "Difference From > $0", or Top 10 Difference From, Bottom 10 Difference From, etc.

Does anyone have any ideas on how to accomplish this?
Thanks in advance,
blimbert

 

[GlennUK]

Can you explain, if you had an output like this, what your filtering would show:

 

[blimbert]

Hello - I have found a solution to the original issue. Cross posted at another forum: Pivot Table Filter On "Difference From"

Solution involved created a dates table, power query, and measures in the pivot table.

 

[GlennUK]

Hello - I have found a solution to the original issue. Cross posted at another forum: Pivot Table Filter On "Difference From"

Solution involved created a dates table, power query, and measures in the pivot table.

That's great. Thanks for the feedback ... the solution contains many fascinating aspects.