I got a pivot table with a Sales Value Field showing values for 2020 and 2021.
I am showing the 2021 sales values as difference from the 2020 values (Diff-2021-2020).
If I perform a Top Ten Value Filtering on the country filed, the filter does not work correctly.
The value top ten-Filter shows:
But actually the top 10 Filter should show ...
Is this a known bug or am I doing something wrong??
Or could somebody come up with a macro code that produces the correct result?
I have attached a sample file for your convenience.
Help is very much appreciated. Thank you very much in advance.