Top 20% Filter that goes over 20% if the value comes within 20%

[Jenn3301]

Hi there,

I have this report where I need to identify the top 20% of a material.

When I put the filter on I only get the top 13% but would like to include the next value that will get us to the 20% mark (even if it goes over the 20%).

Can somoeone help me? I want it to show the two items in the red box in the first image. I've tried searching but I dont think I am wording myself correctly to find a solution.

Thank you.

[amitchandak · Accepted solution]

@Jenn3301 , Follow the approach. You need filter measure based on a group by

Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw