Alteryx Designer Desktop Discussions

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

Sum if they are part of the same group

BautistaC888
8 - Asteroid

Hello,

I have the following database

BautistaC888_0-1623680356456.png

And i need to sum the row values if the duplicate control is equal.

BautistaC888_1-1623680477359.png

Thank you.

2 REPLIES 2
Luke_C
17 - Castor

Hi @BautistaC888 

 

The summarize tool will do the trick:

 

Luke_C_0-1623680664079.png

 

Pingu
10 - Fireball

Hello BautistaC888,

 

You can do this by adding a summary tool:

 

Group by ID

Group By JURIS

Sum Vlaue

Group By Deplicate control.

 

Example attached.

Labels