Only show top N items for given filter selection

Spencer_2

New member
Joined
Nov 29, 2016
Messages
13
Reaction score
0
Points
0
Maybe the obvious is evading me... What is the best method to accomplish the following in Power Pivot:

Only show "items" that comprise 80% of a sales value for a given filter selection. i.e. East, West, South, etc.

Right now I'm simply using "SHOW TOP 20" in the Pivot Table Value Filter.

This ends up showing more items than a straight 80% of sales. I have been playing with Calculate and Filter options but not success yet.

Thanks for any tips...

Spencer_2
 

Spencer_2

New member
Joined
Nov 29, 2016
Messages
13
Reaction score
0
Points
0
Just read thru this... Good stuff but a bit more complex than my current situation demands. Thanks for the tip.
Spencer
 
Top