1 of 1 people found this helpful
I'm on Tab 7, so can't provide the workbook for you (assuming you can't upgrade), but here we go:
One case calculation to apply the weight (called Weighted Rank below):
when 1 then 3
when 2 then 2
when 3 then 1
Quick table calculation on the viz to show percent of total:
This gets me started.
By the way, I've upgraded to 7.
This is pretty close to the right answer, but it needs one more step and I don't know how to do that.
In my Excel workbook, I show the manually computed weighted average in Sheet3 - Weighted Average.
The correct answer should be:
Apples : 40%
Oranges : 30%
Pears : 30%
The answer was correct - I turned Stack Marks and that got me the answer.
Jaya, glad to hear it! (It was Alex's correct answer, I just happen to still have 6.1 loaded.)