count of customers contributing 5% sales

[vireshkolagimat]

HI All,

I would like to know how we can show the the no of customers whose are contributing 5% sales to the total sales in text object.

I know that we can achieve the same in straight box by limiting the dimensions but  i need to show it in text object.

Thank you.

Regards,

Viresh

[ignacio_pena]

Hi,

For this example:

LOAD * INLINE [
Client, Units_sold
1, 600
2, 20
3, 300
4, 50
5, 200
6, 150];

I have made the following calculations:

In the text box is the next expression:

=SUM((if(aggr((sum([Units_sold]) / sum(TOTAL [Units_sold]))*100, Client) >= 5, 1, 0)))

Regards,

[vireshkolagimat]

Hi, Thank you. 

Will check and let you know.