vireshkolagimat
Creator III
2019-02-25
03:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
count of customers contributing 5% sales
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
610 Views
2 Replies
ignacio_pena
Contributor III
2019-02-25
09:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
580 Views
vireshkolagimat
Creator III
2019-02-28
12:04 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, Thank you.
Will check and let you know.
566 Views