Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Sum duplicate values in a field to be displayed once

Chirag_Gandhi07
8 - Asteroid

Hi,

 

I have a data set that contains two fields: Serial Number and Payment. For example:


Serial Number               Payment

ABC123                           15.01

ABC123                           15.01                            

ABC123                           24.97

DEF456                           18.12

DEF456                           39.90

DEF456                           17.13

 

There are duplicate serial numbers and some have the same payment amount. How can I take the sum payment amount for same serial numbers. So, for ABC123, how can I have that record displayed once with the payment being 54.99?

 

Any help would be greatly appreciated

1 REPLY 1
Thableaus
17 - Castor
17 - Castor

Hi @Chirag_Gandhi07 

 

Use Summarize Tool.

 

Summarize.PNG

 

Group BY Serial Number and Sum Payment.

 

Cheers,

Labels