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

Thank you all for your suggestions.  The problem still exists when moving the formula over to the real data.  The starting number for week one is not 1/13 of the total  for 13 weeks.  I think it is because the real data has more than 1 quarter of data.  

 

I would like to share the real data, but it is confidential and I cannot share outside of my organization.

 

Again thanks for your assistance.