Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Regards,
Bill
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.
You can use straight table and dimension limit >" show only values that accumulate" to option.