
1. Re: Weighted Average calculation
Alex Kerin Feb 10, 2012 6:33 PM (in response to Jaya Sinnathamby)1 of 1 people found this helpfulI'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):
case [Rank]
when 1 then 3
when 2 then 2
when 3 then 1
end
Quick table calculation on the viz to show percent of total:

2. Re: Weighted Average calculation
Shawn Wallwork Feb 11, 2012 6:20 AM (in response to Jaya Sinnathamby)Jaya, here's Alex's solution in 6.1

FruitSamplingAK.twbx.zip 20.5 KB


3. Re: Weighted Average calculation
Jaya Sinnathamby Feb 11, 2012 7:06 AM (in response to Alex Kerin)Thanks.
This gets me started.
By the way, I've upgraded to 7.

4. Re: Weighted Average calculation
Jaya Sinnathamby Feb 11, 2012 7:09 AM (in response to Shawn Wallwork)Shawn,
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%
Thanks.
Jaya

5. Re: Weighted Average calculation
Jaya Sinnathamby Feb 11, 2012 7:49 AM (in response to Shawn Wallwork)Shawn,
The answer was correct  I turned Stack Marks and that got me the answer.
Thanks guys.
Jaya

6. Re: Weighted Average calculation
Shawn Wallwork Feb 11, 2012 8:12 AM (in response to Jaya Sinnathamby)Jaya, glad to hear it! (It was Alex's correct answer, I just happen to still have 6.1 loaded.)