Multi Level Hierarchy with Totals

Question

Hello,

I am trying to do some data prep in Alteryx designer for a product hierarchy.

This is what the current data set looks like:

This is what I need the final data set to look like:

I need it completely automated and dynamic so it could handle as many levels as needed.

Thanks!

a

rafalolbert · Accepted Answer

Hi @agilleland17,

This is what i have, i don't think you can fully automate this.

For every level/layer you calculate aggregates and union it all together at the end retaining order top to bottom:

Thanks,

Rafal

#Excuse me, do you speak Alteryx?