AnsweredAssumed Answered

Grand total for subsummaries when using two sub summuaries on a layout

Question asked by eekamouse on Jul 10, 2010
Latest reply on Jul 12, 2010 by philmodjunk

Title

Grand total for subsummaries when using two sub summuaries on a layout

Post

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

Untitled-1.jpg

Outcomes