Alteryx Designer Desktop Discussions

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

Sum columns based on column headers

Klachner
7 - Meteor

Can someone help me sum data in columns based on column header names. I've attached an excel example

5 REPLIES 5
binuacs
21 - Polaris

@Klachner use the dynamic select tool to get the column total. You can use the sample workflow attached

 

image.png

Klachner
7 - Meteor

Thanks binuacs, is there a way to sum the jurisdiction by invoice number. attached an example.

Raj
16 - Nebula

@Klachner just Group by the invoice no in the summarize tool before calculating the sum

you will get the result required.

binuacs
21 - Polaris

@Klachner 

 

image.png

nagakavyasri
12 - Quasar

@Klachner Another way:

 

Screenshot 2024-02-27 143933.png

Labels
Top Solution Authors