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
Solved! Go to Solution.
Solved,
Used 2 multi row, the first that captured the total then a formula that firuged PCT.