Forum Discussion
Solved
show accumulated %
Hi
It is easy to show the % of sales for each cusotmers, but how can i get the accumulated sales%? like cusotmer A+B is 75% A+B+C=90%. Thank you so much
| Customer | SALES | % of total sales | % | |
| A | 100 | 50% | 50% | |
| B | 50 | 25% | 75% | (50+25) |
| C | 30 | 15% | 90% | (75+15) |
| D | 20 | 10% | 100% |
Hi WENBOJIANG ,
Create an index column in Power Query.
Add an index column - Power Query | Microsoft Learn
Then create a calculated column like below:
Column = CALCULATE(SUM('Table'[% of total sales]),FILTER('Table','Table'[Index]<=EARLIER('Table'[Index])))
1 Reply
Hi WENBOJIANG ,
Create an index column in Power Query.
Add an index column - Power Query | Microsoft Learn
Then create a calculated column like below:
Column = CALCULATE(SUM('Table'[% of total sales]),FILTER('Table','Table'[Index]<=EARLIER('Table'[Index])))