Problem with sum calculation in straight table

[venkatg6759]

Hello All,

I have a straight table which gives weights which is a dimension and % bad which is an expression ,weighted% bad another expression.

Weight      % bad           Weighted &bad   Filed

0.5%            0.8%            10%                Australia  

Weighted %bad =%bad* weights   

I want to get the weighted%bad sum for each field .For that i should get weights sum in the dimension.Can anyone help me to fix it.

The result would probably be like this

Weight                       Sum(%bad)       Weighted%bad             Field

10% (which is total)          3.5%               35%(which is total)

5%                                                      2  %                            Austrailia

2%                                                     3%                          America

Thanks,

Venkat

[#2]

Attach a qvw would help.  Thanks.

[Clever_Anjos]

Which expression is "%bad* weights  "?

[Clever_Anjos]

So we shoud rewrite your expression using a AGGR function.

Are you familiar with this function?

[Clever_Anjos]

Is difficult trying to help without your data.

Maybe you could use some "Scramble" (Document Properties/Scrambling) to mix-up sensitive data and post a qvw