1 Reply Latest reply on Jul 12, 2010 8:40 AM by philmodjunk

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

    eekamouse

      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