Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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