Subtotaling range of values

[dottman]

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!

 

 

[Prometheus · Accepted solution]

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

 

 

 

[grazitti_sapna]

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