community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Create accumulated sales column

Meteor

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

foto1.JPG

 

and here's how cumulative sales should be calculated

 

picture 2

foto2.JPG

 

Please, could someone help me with this?

 

Thanks!

Alteryx Certified Partner

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.

Highlighted
Alteryx Certified Partner

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

Meteor

xactly what I needed! Thanks CharlieS!

Meteor

Labels