How many customers make up 80% of sales

[marinasbc]

I've been trying to use the aggr function to get the number of customers that make up 80% of all sales in a text object - can anyone help?

So far I've got

=count({<Customer={"=(rank(sum({<Customer=>}Amount ),4)-1) / Count({<Customer=>}distinct total Customer) <0.20"}>}DISTINCT Customer)

[swuehl · Accepted solution]

Have a look at

Recipe for a Pareto Analysis – Revisited

[vishsaggi]

Check here if this can help:

Recipe for a Pareto Analysis

[marinasbc]

Hi Stefan,

That was actually my first try but it didn't work... Or so I thought! It turns out it takes around 10minutes to calculate the text object....

The expression is:

=Count(Distinct

     Aggr(If(Rangesum(Above(Sum({<Customer=>} #Amount)/Sum({<Customer=>}total #Amount),1,RowNo()))<0.8, Customer),

    (Customer,(=Sum({<Customer=>} #Amount),Desc))

    )

)

Thank you for your help