For some reason the solution is eluding me so I ask with extreme thanks (also please forgive the possibility that the answer is just running away from me):

Office Month Sales Receipts Gross-%
1 1 100000 40000 40%
1 2 110000 41000 37%
2 1 500000 100000 20%
2 2 520000 110000 21%

For each line there is a net collection percentage of Receipts / Sales.

On the group footer for Office, I am drawing a blank on how to create the same group footer total of Receipts / Sales in that group footer?

Thanks in advance.
--rab