rangesum with multiple dimensions

[curiousfellow]

I have a pivot table with three dimensions:

1. Calculated dimension (calcdim)

2. Week

3. Year

The year-dimension values are columns

I want a running total over calcdim and week

I use this expression :

=rangesum(above( count(distinct employees)  ,0, rowno() ))

When calcdim is collapsed running total is  calculated correct but when expanded , every calcdim it starts from zero.

Is it possible to keep the cumulative total running ?

[Anil_Babu_Samineni]

May be look here How to use - Dimensionality()

[swapniltaz]

Use the below expression and check if it helps , Use of Total can help you with that 

=rangesum(above( Total count(distinct employees)  ,0, rowno(Total) ))