Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Month to Month Total Price

mehmetalikarabulut
6 - Meteoroid

Suppose you have a chart like below. List the total monthly sales amount of all products using the sales in 2007, month by month, in different columns. How can I do that? For example :

 

1.png

2 REPLIES 2
jamielaird
14 - Magnetar

Hi @mehmetalikarabulut ,

 

There are a few ways to do this. Here's one, that I've broken out into seperate tools to make it easier to annotate and explain what's happening:

 

jamielaird_0-1613997009159.png

jamielaird_1-1613997025163.png

 

 

 

 

 

Hope that helps!

SeanAdams
17 - Castor
17 - Castor

Hey @mehmetalikarabulut 

 

3 steps:

a: create the column name that you want using a formula tool (based on the date)

b: summarize tool to add up for that month - now you should have a vertical list of months with totals by product; by month

c: Use a cross-tab tool to turn rows of months into columns

Labels
Top Solution Authors