Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is there a way, with a formula, to get the number of items (count distinct of a field) that makes the 80% of sales (sum of sales field ordered top-down)?
For example, if I have:
Product Code | Sales |
---|---|
Product 01 | 500 |
Product 02 | 200 |
Product 03 | 300 |
500 (Product 01) + 300 (Product 03) = 800, that is the 80% of total Sales field, this means that result is 2 (count distinct of Product 01 and Product 03).
By searching in the community I've not found anything to get the result...
Many thanks in advance!
Regards,
Davide
May be this?
Count({<[Product Code] = {"=Avg(Sales) = 0.8"}>} DISTINCT [Product Code])
May be this
Count({<[Product Code] = {"=Aggr(RangeSum(Above(Sum(Sales), 0, RowNo())), ([Product Code], (=Sum({<[Product Code]>} Sales), Desc)))/Sum(TOTAL Sales) <= 0.8"}>} DISTINCT [Product Code])
Hi,
I have found the solution by following both links (Pareto and ABC), Pareto for chart and ABC for table:
Many thanks!!
Regards,
Davide
Hi All,
Thanks to all for the quick help!
Regards,
Davide