Skip to Content
0
Former Member
Aug 22, 2012 at 09:02 PM

Summary totals in the group footer with detail section dates

10 Views

Hi All,

I have a report like this,

Manager Name: XYZ

1-Account Status:Active

PostingDate New Used Cancel New Used Cancel

1/2012 1 2 0 1/2011 0 4 3

2/2012 0 1 1 2/2011 5 8 6

2-Account Status:Active

PostingDate New Used Cancel New Used Cancel

1/2012 4 5 2 1/2011 3 2 1

3/2012 2 1 1 3/2011 2 8 4

In the group footer, I need a total for the manager to look like this (Summarizing the values in the months for all the accounts)

1/2012 5 7 2 3 6 4

2/2012 0 1 1 5 8 6

3/2012 2 1 1 2 8 4

Any help is appreciated.

Thanks