Sum of Sums...

[Nitesh9999]

Hi, I need to sum the sums of groups (stay with me!).

This is the rough report layout:

DETAIL SECTION in red
GROUP FOOTER in blue


Value

5
77
12

Sum (this sum works)

5
3
5

Sum (this sum works)


Grand sum (Sum of the 2 sums in above example)

Ive tried putting the grand sum in the page footer so its not repeated (I only need it once) but i always just get error.

The picture below is of the 2 sums. The blue circled box is the problem (text61). The red is what i am trying to sum.

 

[Rich]

You can't display Sums in the page footer by that method,
Article ID: Q132017

 

[Nitesh9999]

How would i be able to put a grand total then? And is it actually possible to to sum the sums as it were?

PS what is that article ID (I'm a pain but i learn).

Edit - I figured out the article ID Long live google...