Regarding % calculation

[sarfaraz_sheikh]

Dear All,

I want to calculate %Calculation like below ...

                                AFabulous              BPerformance                            CExcellent                                DVeryGood

Sum of salary               212000                    104000                                    57000                                        68000

% Calculation              100%             104000/212000*100=49.05%      57000/212000*100= 26.88%      68000/212000*100= 32.07%

Snapshot is also attached here for more clarity of understanding....

In 1st snapshot there is no expression added called %Calculation

In Second snapshot the %Calculation expression showing wrong percentage. i want %Calculation to be shown in Total Mode only... not with Dimension's ..is it possible ,if yes then suggest me how i can achive the same with above calculation.

my Qvw is also attached here for your reference.

Sarfaraz

[#2]

Try this

=Sum(SALARY) /Sum(TOTAL {<Remarks={'AFaboulous'}>}SALARY)

[fvelascog72]

If I have understand correctly you can try Sum(SALARY) /Sum(TOTAL SALARY)

[buzzy996]

use this,

expression: =Sum(SALARY) / Sum({<Remarks={'AFaboulous'}>} Total SALARY)

[Anonymous]

check out the attached qvw for solution

[jonathandienst]

Hi

The expression should be =Sum(SALARY) / Sum({<Remarks={'AFaboulous'}>} Total SALARY)

And the number format should be set to fixed/percent.

HTH

Jonathan