I have a report with two groups. Group 1 by Client and Group 2 by Type of payment. I would like to be able do a grand total broken down by the different Types of payments (group 2). I believe this needs to be a running total of some sort, but I cannot seem to find the right evaluate and/or reset combination. Essentially I want a running total of the Type of payments across all Clients. Is it possible to do a running total of a group sum field?

Mockup:
Client 1
           PayType 1
                          $10
                          $10
                          $10          
           PayType 1 Tot $30
           PayType 2
                          $20
                          $20
                          $20          
           PayType 2 Tot $60
Client 2
           PayType 1
                          $10
                          $10
                          $10          
           PayType 1 Tot $30
           PayType 2
                          $20
                          $20
                          $20          
           PayType 2 Tot $60

Grand Total PayType 1    $60
Grand Total PayType 2   $120

No there is not duplicate data. I am actually not using running totals. I am using regular groups and group footer sums. I am wondering if running totals is the way to get a grand total broken down by group 2 payment types. The payment types are configurable by the client so they are dynamic making a static sumif forumula unusable. Thank you in advance if there is another way to do this.

Thank you. That will work. Had not considered that.