Sum problem

[alexal]

 Hello.

I have created a report, which looks like this:

 

Group 1

a    5 /*5=$F{Count}*/

b    13

c    2

Sum: 20 /*20=$V{Count_1} aggregated as sum from $F{Count}*/

 

Group 2

d   2

e   8

Sum:10

I want to modify it to look like this:

Group 1

a    5     25%

b    13   65%

c    2     10%

Sum: 20 /*20=$V{Count_1} aggregated as sum from $F{Count}*/

 

Group 2

d   2      20%

e   8      80%

Sum:10

I tried to use $F{Count}/$V{Count_1} expression.

The problem is, that sum is calculated for each row and so only final row's percentage displays correctly (c and e rows in my example). The first one (a, d) would always show 100%.

How can i make this persentage to display correctly and use variable value wich is displayed in group footer?