grand total outside table?

[patrickw777]

Gurus,

How do I put a grand total outside the table?
I have a total at the bottom of each block and then a total of those totals at the very bottom, but I want to put the grand total on the top of the report. When I drag it outside the table, the numbers go away. I've tried some formulas to no avail.

1. 1 1 1
1 1 4
-----
2 2 5
2. 1 1 1
3 1 1
-----
4 2 2
---------
6 4 7 <- I want this outside my table


Thanks,
Patrick

 

[skrandel]

Just build a cell at the top of the report. Put a copy of your measure in the cell and it should work fine.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[blom0344]

In some cases making a copy of the table and then folding the entire copy does the trick very nicely. Place the folded copy above the detail table and format properly...

T. Blom
Information analyst
tbl@shimano-eu.com