Forum Discussion

merath01's avatar
merath01
Regular Visitor
6 years ago

Create a formula for cumulative total

Hello, I am trying to create a measure (or column) that calculates the rolling cumulative sales in a linear format for a table or matrix.  I know the sales and create a formula for the Cumulative Sa...
Need Help
merath01's avatar
merath01
Regular Visitor
6 years ago

Thanks for your assistance.  I still can't get it to work with my real data, the numbers are too low.  I did notice that the total on your example did not equal the 242 total sales, which it should.  Any thoughts?

 

Thanks again!

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

I don't know why it isn't working with your actual numbers. I'd need to see sample data. I don't know what "too low" means. 

 

As to the total, I should have removed that. The total in this matrix is useless as it is an average. But if my data was sorted properly (I didn't bother setting up a sort-by-column setting) it would show 242 for the final week.