contribution

[#1]

Hi All,

I would like to show the count of customers whose contribution is greater than 20 %  in a text object how can I get it.

Regards

John

[prma7799]

can you please share some data?

[#3]

Hi Prashant

PFA. Thanks.

Regards

John

[petter]

Is the column D some kind of Customer ID?

[b_garside]

Try this example; it will display top 2 customers.

Perhaps you can modify it to show top 20%.

By changing this portion;  Sum(Sale) to a percent calculation

=concat ( IF( aggr ( Rank(sum(Sale)),CustomerID)<=2, CustomerID & chr(10)))

[#6]

Yes