I want to have only the second level grouping have a footer with aggregate values. Not sure how to go about it.
________________________________________________________________________________
Group1 - need total in header
----- Grouping 2
----- Grouping 3
++++++++++++++++++++++|++++++++|+++|+++++|+++|++++++|+++|+++++++++++++
++++++++++++++++++++++|++++++++|+++|+++++|+++|++++++|+++|+++++++++++++
++++++++++++++++++++++|++++++++|+++|+++++|+++|++++++|+++|+++++++++++++
++++++++++++++++++++++|++++++++|+++|+++++|+++|++++++|+++|+++++++++++++
++++++++++++++++++++++|++++++++|+++|+++++|+++|++++++|+++|+++++++++++++
==Footer for 3 (need blank) ============================================
=============Footer for 2 ========================(NEED SUMS HERE==============
================Footer for 1 (need blank)============================================
================Footer for Grid (need blank)==========================================
_________________________________________________________________________________
Since a picture is worth a thousand words. Check out the attached pic for an idea of what I mean (not the above).