Hi,
I have a very large list of products and their associated sales.
The large list of products is making my workbook very unresponsive.
Is it possible to create a filter that cuts off the Pareto chart at the 80/20 cutoff?
Thanks
John,
I'm not sure if this is quite what your looking for,
but maybe it can give ideas.
I created the Pareto in the standard way using
a quick calc of running sum and then the secondary calc of percent of total.
Of note, I just did the 80% of sales part. I'm not sure how you want to
filter the 20% of products part.
I think drug that table calculation pill to the measures pane and a new calculated field was created:
RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales]))
I then created a filter field of:
[Running Percent]<=.8
and put that on the filter shelf.
Please see workbook v10.5 attached in the Forum Thread:
Filtering Pareto chart to retain just the 20% of products that make up the 80% of sales
