Alteryx Designer Desktop Discussions

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

Repeating rows and Sum Values

neromerob
10 - Fireball

Hello to everyone. 

 

I have been working on a workflow but my output is showing repeating rows, the thing that i want to do is  not to show repeating "codes" but maintaining the sum values of each row, consider that new "months" is a dinamyc variable (March_2022, April_2022, May_2022 and so on)

 

Summatory.jpg

thank you 

3 REPLIES 3
binuacs
20 - Arcturus

@neromerob one way of doing this

binuacs_0-1655820203988.png

 

Luke_C
17 - Castor

Hi @neromerob 

 

Here's how you make it dynamic (note numbers are different as I don't have time to re-type your screenshot)

 

Luke_C_0-1655820502923.png

 

Robin_McIntosh
11 - Bolide

Here's an example.

Labels