Skip to Content

Grouping Running total result at group footer

I have a report which is sample as below

Page Header: Category Account# Jan Feb Mar Apr

Group Header: (group by Account# and suppressed)

Details (Suppressed)

A 123 5 4 1 2

A 456 3 1 2 4

B 789 1 3 3 1

B 378 2 1 1 4

Group Footer (Running total) from Details

A 123 5 9 10 12

A 456 3 4 6 10

B 789 1 4 7 8

B 378 2 3 4 8

I can get to the above but getting stuck on how to summarize the group footer by the Category. It should look like:

A 8 13 16 22

B 3 7 11 16

The running total has to be at the account level first before can summarized into category

Any suggestion is very appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Dec 18, 2018 at 10:29 PM

    Why not to add top Grouping by Category?

    Add comment
    10|10000 characters needed characters exceeded