Alteryx Designer Desktop Discussions

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

Multi Row

Watermark
12 - Quasar
12 - Quasar

Here is a snip of a income table by zip.  I want to create the Pct Total column by doing the formula you see I inserted. 

NOT every zip code will have all 6 lines. Some will some won't. Yes, I could insert those that are missing, but trying to figure out a formula in the multi-row that will know combo of zip and code 0 is the denominator.  Thoughts?   TIA

WaterMark_1-1611375507970.png

 

 

1 REPLY 1
Watermark
12 - Quasar
12 - Quasar

Solved, 

 

Used 2 multi row, the first that captured the total then a formula that firuged PCT. 

Labels