Grand total for subsummaries when using two sub summuaries on a layout
Hello I have imported some data from another applicaton as follows:
Date of file
# refunds of issued for file date
amount of refunds issued for file date
I have added a field "Source" of the data to distingiush each file since there are two ways these files get generated one by our own customer service and a second by someone else
I have managed to group all the data in order to summarize the files by month and year by creating a sub summary and a trailing grand summary and relevant summary fields.
What I then tried to do is add another sub summary part in order to separate the totals by "source" which does not allow for a grand summary by Source only all the data combined in the trailing.
I understand that the trailing is for everything but is there a way to get a sub total?
Is there a different way to get a grand total by source to display?
I have included and image of the report and two of the layout