troubleshooting Question

Value Filter Top Ten not working correctly.

Avatar of Andreas Hermle
Andreas HermleFlag for Germany asked on
Microsoft OfficeMicrosoft ExcelSalesVBA
15 Comments1 Solution37 ViewsLast Modified:
Dear Experts:

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.


Regards, Andreas


EE-top-10-items-not-working-correctly.xlsm
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 15 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros