Hi Community!
I need to calculate a cumulative sales considering 3 variables (in this example): period (year-month), country and product.
Example.... picture 1 shows sales history during 2019 01 to 2019 03, to 2 countries and 3 products.
picture 1
and here's how cumulative sales should be calculated
picture 2
Please, could someone help me with this?
Thanks!
Solved! Go to Solution.
Use the Running Total tool.
https://help.alteryx.com/current/RunningTotal.htm
The tool settings in this case should be Group By: Country, Product, then Create a Running Total for the Sales field.
Hi @brunod you can do this using the running tool or the multi-row formula tool.
Exactly what I needed! Thanks CharlieS!
Thank you JS420! It worked! It's good to know different ways to solve a problem!