Create accumulated sales column

[brunod]

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!

[CharlieS · Accepted 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.

[JosephSerpis · Accepted solution]

Hi @brunod you can do this using the running tool or the multi-row formula tool.

[brunod]

Exactly what I needed! Thanks CharlieS!

[brunod]

---

Thank you JS420! It worked! It's good to know different ways to solve a problem!