Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 
Partner - Creator
Partner - Creator

How to limit the displayed data up to 80% cumulative sales?

One of the client's requirements is the TOP SKUs with 80% cumulative sales distribution. From the list, the SALES amount must be SORT DESCENDING. Then start accumulate the sales distribution. So, after full accumulation, I want to remove the SKUs that are greater than 80 percent. How could I do that? Is it possible? Please see image below for your reference.




2 Replies

Use a straight table and set the limit on the Dimension Limits tab to filter the rows based on the values of the first chart expression.

talk is cheap, supply exceeds demand
Creator III
Creator III

You can use straight table and dimension limit >" show only values that accumulate" to option.