Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you please share some data?
Hi Prashant
PFA. Thanks.
Regards
John
Is the column D some kind of Customer ID?
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)))
Yes