cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mgibson78 Frequent Visitor
Frequent Visitor

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

 

 

ThanksCT.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Cumulative Totals

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?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


5 REPLIES 5
Super User
Super User

Re: Cumulative Totals

Are those columns or measures in your data model?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


mgibson78 Frequent Visitor
Frequent Visitor

Re: Cumulative Totals

They are columns

Super User
Super User

Re: Cumulative Totals

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?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


mgibson78 Frequent Visitor
Frequent Visitor

Re: Cumulative Totals

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

Community Support Team
Community Support Team

Re: Cumulative Totals

@mgibson78,

 

If any progress, feel free to share with us.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.