Hi,
No, I don't have the hidden fields. I don't have field in the last column. The sub-total in the "Group by" is calculated from the value on the left on the same line. You can see it in my example. I think when I calculate sub-total in the Group by row, I used the data on each line of record so when I sum up the sub-total, it in fact sum up by using the data in each record.
So, I want to know can I sum up the sub-total which is in Group by row without sum up each record?
Or can I store each of the sub-total in a variable or array, then I sum up the variable or array at the end of the report so to get the Total?
Thanks for helping me again.

>Hello again Power
>
>The problem is that in your last column you have hidden fields and these are being summed, hiding them using print when will only hide them but VFP treats them as if they are still there.
>
>To avoid this then wrap the expressions you are using in your last column as follows
>
>yourexpr=the expression you are using to hide them in the print when dialog
>
>lastcolumn=what ever you have in the column at present
>
>IIF(yourexpr=.t.,lastcolumn,0)
>
>hope this helps
>
>
>
>>Oops I forgot to click Jorge and Mark's name so I now send again.
>>Jorge, in fact I don't have a "year" total, the following will show more clearly about my case.
>>Mark, I have tried to select all the "End of Report", "End of Page", "Month" band in the "Reset at" of the property window, all can't give my need.
>>
>>Sorry that I forgot to preview my message before sent so all the data in the report I wanted to show were messed up. Now let me try your suggestion to use < PRE > to make my report look tidy.
>>

>>$ received in   $ received in           Commision                  Commision
>>last month      this month            in last month               in this month
>>********************************* Nov ******************************************
>>10000                 0
>>    0                 4500
>>10000             10000
>> -----------------------------------------------------------------------------------------------------
>>20000             14500                     4000                              2900 <------ Total of a month, Group by month
>>
>>******************************** Dec ******************************************
>>20000             10000
>>    0                    0
>>10000             10000
>> -----------------------------------------------------------------------------------------------------
>>30000             20000                     6000                              4000 <------ Total of a month, Group by month
>> ----------------------------------------------------------------------------------------------------
>> Total of Commision in this month:                                       9800 <------ Total should be 2900 + 4000 = 6900 in this example.
>>

>>
>>The formula to calculate the commision in this month is :
>>Total $ reveived = total $ received in last month + total $ received in this month
>> if the total $ received < 50000, the commision rate is 0.2
>> if the total $ received > 50000 and < 100000, the first portion of commision is 50000 x 0.2 = 10000, the second portion of commision will be x 0.25.
>> if the total $ received > 100000 and < 200000, .........., etc.
>>So the commision of this month = total commision - commision already got in last month.
>>For example, commision due to Nov = (20000 + 14500)*0.2 - 4000 = 2900
>>commision due to Dec = (30000 + 20000)*0.2 - 60000 = 4000
>>So the total commision in this month = 2900 + 4000 = 6900 which is the final result I want to have in my report.
>>Hope it is much clearer. Thanks for help. I have been studying this problem for more than a week, my mind cannot run now.