Hello everyone,
For a few days, I have been having a problem with Pareto analysis. I have read everything on the forum, but I haven't been able to find a solution.
What I would like to calculate is the distinct number of IDs that generate 80% of the revenue.
I tried using the following formula, but I think it has some sorting issues.
Count({<ID = {"=aggr(RangeSum(Above(Sum({...set analysis...}Sales), 0, RowNo())), (ID, (Sum({< ID >}, Year={'$(=max(Year))'}), Desc)))/(Sum(TOTAL {...set analysis...} Sales)) <= 0.8"}>} DISTINCT ID)
Similarly, I also tried to calculate the percentage of sales generated by the 20% of distinct IDs using the following formula:
Sum({...set analysis}, ID={"=Rank(Sum({...set analysis} sales)) < (Count(TOTAL DISTINCT {...set analysis...} ID) * 0.20)"}>} sales) / Sum({...set analysis...>} sales)
...and this one works well.
Can anyone help me? Thank you.
