Budget Calculations That Change by Level
User Rating: / 0
Written by Rob Collie   
Wednesday, 21 November 2012 19:43

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:




Pyramid Analytics