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.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Create-accumulated-sales-column/m-p/461974
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!
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.
Hi @brunod
When I run the solution from @CharlieS and delete some values from the sales column the value shows as null, but the running total continues.
What is the output you're looking for?
Dan
@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.
Hi @danilang !
If you delete a line, for example, 2019 02, the total running would only show 2019 01 and 2019 03, but its necessary show all three months. @CharlieS gave us a way to do that and it worked.
