Create accumulated sales column

Question

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 Answer

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 Answer

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