Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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