1 of 1 people found this helpful
When you change the measure of 'Quota' to 'Maximum' instead of 'Sum' then it should work to display the data in the way you showed. When you add a calculation for 'Coverage' like, sum([Amount])/(max([Quota])), then the percentage should appear as well. (you might need to change the formatting for that calculated field then, in order to show %)
Hope this is helpful,
Thank you for taking the time to respond! I have tried as you suggest, and am still running into a problem of sorts - while the quota amount (and coverage calculation) is fine per Sales Rep, it is not rolling up for each sub total and total - which is understandable, given that I'm using the Maximum measure. I am therefore wondering if there is something else which needs to be done in order to have the various totals roll up... or indeed if it can be done? In the example below, the Sales Region and Grand totals are calculating Coverage off the maximum individual quota in each, and not the sum of the individual (maximum) quotas. Hope this makes sense!
As you mentioned, the totals will use whatever aggregation is on the measure. To get the rolled up total, the best option is to get the desired total on a separate sheet and place the two sheets on a dashboard together.
Thank you, Tracy!