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
To get a subtotal to print below the group of records it summarizes, specify the Print Below option when creating the sub summary part. You can have both leading and trailing subsummary parts with the same break ( "sort by" ) field.