We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Subtotaling range of values

dottman
7 - Meteor

Wondering if anybody knows how I could turn the top table into the bottom table in Alteryx. Column "701-705" is the sum of that range in image above, ditto for "715-717". Would appreciate any help!

 

 

alteryx.PNG

alteryx.PNG

2 REPLIES 2
Prometheus
12 - Quasar

It's pretty manual, but if you have multiple cases of this same type of subtotaling, I'd find a different way.

 

New Fields.PNG

Desel Old Cols.PNG

Subtotaling Range.PNG

grazitti_sapna
17 - Castor

Hi @dottman I have attached Solution regarding your problem. Hope it works for you.
Thanks

Sapna Gupta
Labels
Top Solution Authors