cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We’re thrilled to announce our newest Alteryx Designer Expert Certified users! Learn more.
SOLVED

grouping

Hello everyone.
I have a base that contains sales information per store, product and month, as shown below:

 

Capturar.PNG

 

 

I need to pick up every seven months and create a period column (Jan16-Jul16 / Feb16-Aug16) by grouping sales together:

 

Capturar2.PNG

 

the sum is made as follows:
- period Jan16-Jul16 was the sale of all the months of this period. In this case I had one sale in July, so the value will be 1.
- period Feb16-Aug16 was the sale of all the months of this period. In this case I had one sale in July and two in August, then the value will be 3.

and so goes for the whole base.

 

Can someone help me?

 

Highlighted

The easiest way as long as the data has all months is:

- Add a running total grouped by Filial and CD_Produto totalling Sales

- Use a Multi Row to get the running total value from 6 rows later

 

You can then use a formula too to produce start and end months

 

Sample attached

Thanks @jdunkerley79, it worked perfectly.

Labels