topic problem in weighted avg in QlikView

problem in weighted avg

Sat, 18 Sep 2010 10:04:37 GMT

i have list of companies with sales,cost,etc

i have calculated the weighted avg of all the comlanies using some formulas.....

if the overall wt.avg is 20% consider........

consider xxx company wt.avg is 24% and yyy is 16%

I want to show the chart with companies list as X-axis

And Y-axis should show the value for xxx is 4% and yyy is -4%

that is we should subtract the value of individual wt.avg to overall wt.avg....

can any one explain how to do this.........

thanks in advance

Sat, 18 Sep 2010 10:19:05 GMT

Hi,

Can you pl post a sample data nad explan us in excel

-Sridhar

Sat, 18 Sep 2010 10:31:57 GMT

Company Profit Depreciation Income

XXXX 20,500 15,000 50,000

YYYY 25000 17000 55,000

ZZZZ 70,000 20,000 80,000

Wt.Avg=(Profit*(Depreciation/Income))/Profit

Wed, 17 Aug 2011 14:06:35 GMT

Hi, have you found any solution for it?