Forum Discussion
Cumulative Totals
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
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?
5 Replies
Are those columns or measures in your data model?
They are columns
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?
