Forum Discussion
Cummulative Value field
Hi everyone,
I have a feild from the data source that shows a cummulative value.
When I use this to create a table chart, the total shows a summed value of the field (2110) instead of the last cummulated value (820), does anyone how how I can fix this:
| Days | Total Sales | Cummulative Sales |
| 1 | 100 | 100 |
| 2 | 150 | 250 |
| 3 | 120 | 370 |
| 4 | 200 | 570 |
| 5 | 250 | 820 |
| Total | 820 | 2110 |
@tobz
You can use this measure instead of the Cumulative fieldCumm New = IF( HASONEVALUE(Table1[Days]), SUM(Table1[Cummulative Sales] ) , SUM(Table1[Total Sales]))________________________
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂
1 Reply
@tobz
You can use this measure instead of the Cumulative fieldCumm New = IF( HASONEVALUE(Table1[Days]), SUM(Table1[Cummulative Sales] ) , SUM(Table1[Total Sales]))________________________
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂