Cumulative Totals

[mgibson78]

Please excuse the crudeness of my image!

Essentially I want to create cumulative totals. So the figures surrounded by the black line are my base figures. Then I would like the figures surrounded by the red line added onto them. Then the green covered figures added to those. A running total if you will. I really hope this makes sense!

So the top line would go 1,3,6

etc etc

Thanks

[Greg_Deckler]

Are those columns or measures in your data model?

[mgibson78]

They are columns

[Greg_Deckler · Accepted solution]

So, could you add an additional column in your data model like [column1] + [column2] + [column3] and then use a Quick Measure Running Total on that column?

[mgibson78]

That's the very thing I'll try! Thanks!

[v-chuncz-msft]

@mgibson78,

If any progress, feel free to share with us.