How to calculate running total on diemensional data at report level?

[shrini]

Hi MFGF,

MY Strucutre is like this --

Name Space:-DM
Dimension- [MonthTime]
Hierarchy- [Month Time]
Level- [YM]
         [Month Time]
         [FSCL_Y]
         TRM_CTGRY]
         [QTR_TRM_CTGRY]
          [YM]

this is my strucutre, so pls let me know how frame the expression.

Thanks,
Shrini
 

[MFGF]

Hmmm - I'm confused.  You seem to have the same level [YM] in your hierarchy twice - at the top and at the bottom.  This doesn't make sense - you can't have the same named level in two different places in the same hierarchy.  Could you double-check this?  Also, do you definitely have a second level called [Month Time]?

If I ignore the first two levels you included, it seems to make more sense:

FSCL_Y              your Fiscal Year level?
TRM_CTGRY        your Term Cagegory level?
QTR_TRM_CTGRY your Quarter Term Category level?
YM                    your Month level?

Is this your hierarchy structure, or are there really two more levels?

Thanks,

MF.