Hi Community!
In discussion bellow (link bellow) I needed help to calculate the cumulative sales, but I found somenthing new I need some help again.
I used 'running total', but I found something... when a country-product doesn't have a sales in especific period (year-month), the cumulative total sales to that period is equal to zero.
How can I fix this?
Thanks!
Solved! Go to Solution.
I took the solution from yesterday and removed some rows. I started by using Summarize and Append tools to create a list of all possible Country/Product/Month combinations. Then I Unioned this with the original data and took the max available Sales value.
Once this information was compiled, the application of the Running Total tool was the same.
@CharlieS wrote:I took the solution from yesterday and removed some rows. I started by using Summarize and Append tools to create a list of all possible Country/Product/Month combinations. Then I Unioned this with the original data and took the max available Sales value.
Once this information was compiled, the application of the Running Total tool was the same.
Thank you @CharlieS ! It works!
And I need to sort data by period before running total, otherwise it won't sum in the correct chronological order.