I need to do what I’ll call both “Vertical” and “Horizontal” calculations at the same time. What is the best way to accomplish this?
In this fake example, each street is a different length, so the snow plower charges a different rate for that street. However, the HOA wants to charge everyone the SAME amount. So we don’t need the cost per lot that I can calculate using an equation in the table.
I can do the “vertical” sum of the # of Lots and the Cost in a pivot table report, but I can’t do the “horizontal” division equation that would result in the yellow-highlighted amounts.
The only thing I have thought of so far is to make a connected parent table of Neighborhoods and streets and then do the calculations there… but I worry that will make all my table edits take longer.