Forum Discussion
sum of 20%
Hi, I m using the following measure to get the sales of top 20% customers. How do I sum the sales of these 20% and show as a % of the total sales: sales of 20% = if(ISBLANK([salesttl]), Blank(),I...
Hi Thanks Greg_Deckler , But thats also giving me 100. My data is looking something like this with the measure I provided in post:
| Cluster | Product | % of total mkt sales | Top 20% sales |
| MA | Prod 1 | 15.54% | 491,278 |
| MA | Prod 2 | 11.36% | 359,314 |
| MA | Prod 3 | 8.15% | 257,596 |
| MA | Prod 4 | 6.69% | 211,559 |
| MA | Prod 5 | 6.53% | 206,382 |
| MA | Prod 6 | 6.14% | 194116 |
| 100% | 50,000,000 |
Market sales: 3.2 million
total regional sales: 50M
MX sales contr of top 20% products to regional sales : 1,720,245/50m = 3.4% >> I would like to show this result in the card.
Also, in the table I m seeing the regional sales in the total instead of the market total sales and in the % column I'm seeing the sales as % of the market sales (3.2m) but in total it is showing 100% (when in fact it is around 54%)
v-juanli-msft
Community Support
Community SupportHi Anonymous
I don't kwow how to define the top20% product?
It is defined by "market sales" or "top20% sales"?
You could show some short raw data for me to test.
Best Regards
Maggie