summarize multiple layered positions

tiverson

I have an account mapping where I need to roll up lower levels and summarize the data

Currently, I have my data at the non highlighted level (ie..B011010, B011050, B013110, B013150, etc)

I need to figure out what is the easiest way to add the next level to the data.  Once I add this layer, I can summarize what I need

BS map test.xlsx

ChrisTX

The quickest option may be to use 4 Multi-Row Formula tools, for fields Node1 to Node 4, to copy values down to a blank row below.  Then filter our rows where Node5 is blank.

Here's the tool mastery article: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p/86603

In Alteryx Designer, click Help > Sample Workflows > Learn one tool at a time > Preparation > Multi-Row Formula

Chris