Hi there,
I have a pivot table where I want to filter the top 10 value (gap of 2019 vs 2018) and I am not able to do it properly due to mix of positive and negative value.
If I use the Value Filters --> Top 10, I get the top 10 absolute value, but I want only the positive one.
I will get so far 10, 14, 16 but also -20. And I don't want to show this one, I want to top 10 positive value.
Any idea to do it?
Thank you
I have a pivot table where I want to filter the top 10 value (gap of 2019 vs 2018) and I am not able to do it properly due to mix of positive and negative value.
If I use the Value Filters --> Top 10, I get the top 10 absolute value, but I want only the positive one.
I will get so far 10, 14, 16 but also -20. And I don't want to show this one, I want to top 10 positive value.
Any idea to do it?
Thank you