Budget Calculations That Change by Level
Sales and Stock Tables
The question is pretty simple - I have a Sales table and a Stock table:
And we want a measure that returns Percentage Sold.
But there's a twist: at the Shape level, we want to use something other than Stock as the total. We want to use another cap, a Shape-Level cap: