Hi Guys,
I am trying to design a report where I need to show the following Hierarchy:
D.0307.01.01 TL
   D.0307.01.01.01 text1
     D.0307.01.01.01.01 M
     D.0307.01.01.01.02 L
   D.0307.01.01.02 text2
     D.0307.01.01.02.01 M
     D.0307.01.01.02.02 L
   D.0307.01.01.03 text3
     D.0307.01.01.03.01 M
     D.0307.01.01.03.02 L
D.0307.01.02 SL
   D.0307.01.01.01 text1
     D.0307.01.01.01.01 M
     D.0307.01.01.01.02 L
   D.0307.01.01.02 text2
     D.0307.01.01.02.01 M
     D.0307.01.01.02.02 L

In this format:
     Budget Value
TL     
M     $xxxxx
L     $xxxxx
SL     
M     $xxxxx
L     $xxxxx

So basically M and L totals for TL as one group and the same for SL as another group. The Child level of TL and SL can vary but the levels where the M's and L's are will stay the same.
For starters I am able to create a group for TL and suppress SL to show all M's for TL (will do the L's after). So now I have all the M's for TL showing in separate rows, but I need to combine them into one row with totals for M adding up under TL. I am able to identify the individual node names but cannot add up M. One other way I used was by using the running totals on M but then how do I get just the last row for M?
I hope my explanation is clear enough. Your help will be very much appreciated.

regards,
Daan.

Edited by Daan - 26 Sep 2011 at 9:04am

I am not the Running Total expert, DBlank is, but I do the same thing in code using formulas and shared variables.