Kroner.png

In the first picture the Pivot Table is showing the profit of each city in 2010 and 2012. Where I used Sort & Filter Largest to smallest, in order to display the cities with greatest profit.

Prosent.png

But when I switch the values to `% of` year (Previous). I get the change from 2010 to 2012 in percentage.
But my PROBLEM is when I want to Sort & Filter from Largest to Smallest, cause I want to show the cities that have had the greatest percentage change from 2010 to 2012. But the I only get the same cities, and when I look at ex. ´Gjøvik`is has had a 125 % in change and should be in the top.

So how am I able to Sort & Filter from Largest to Smallest the cities with greatest change in percentage?

Thanks in advance.

Thomas.