Hi Everyone,

I need to weight my percent of change by province. E.g.

2004 2005 2005 Distribution % Change Weight
AB 182 268 6% 47% 2.8%
MB 1,285 1,295 29% 1% 0.2%
SK 784 887 20% 13% 2.6%
TOTAL 4255 4455 4.7% 5.7%

I see that MB has 29% of the market share, but only a % change of 1% in
volume.
AB has a small market share 6%, but is pulling the % change way up. But why
doesn't my weight formulas add up to total % change 4.7<5.7?
My weight formula is 2005 Distribution times % Change.