Crystal Reports grandtotal

Message

   My report structure is like 

group #1        | value1    value1/grandtotal   

report footer  | value1total        

so the report should look like :

name1    5     25%            

name1    5     25%            

name1    5     25%            

name1    5     25%            

total      20    100%

but I got 

name1    5     100%            

name1    5     50%            

name1    5     33%            

name1    5     25%            

total      20    100%

I tried to use a dummy formula field that is written like : 
whilereadingrecords; 
"";

and for grandtotal 
evaluateafter({@dummyformula});
(so that the percent calculation hopefuly takes places after)
This doesn't work.

"insert summary" would not work as I have more one columns.
I cannot use "cross-tab" due to its design limit.
"SQL command" wouldn't work because this report takes two parameters, which are start and end date. 

Please tell me how to get the actual grandtotal in group section.

Edited by zakal1983 - 24 Dec 2009 at 10:56am