How to show cumulative sum in pivot table based on second dimension?

[#1]

Hi All,

I want to show cumulative sum in pivot table for the second dimension. To help you understand the exact requirement I am attaching a snapshot

AY and CY are my dimensions and the expression which I have used in the bottom table is:

rangesum(above(total(sum{<conditions>}value),0,RowNo(Total)))

In the attachment I have two pivot tables the one in top is what I want with some modification

so my first row should have cumulative numbers for AY = 2008 from the bottom table and so on

Any help will be highly appreciated

Regards,

Sagar Gupta

Jagan Mohan jagan mohan

[Gysbert_Wassenaar]

Can you post a document with some data instead of a screenshot?

[#3]

Hi Gysbert,

Thanks for your quick response.

It will be difficult for me to post the file, but i can explain you in detail:

I have 6 dimensions namely AY, Quarter, Month, CY, Quarter_1 and Month_1

and i am enabling them on the click of a button

case:1 - AY and CY will be active

case 2: AY, Quarter and CY, Quarter_1 will be active

case 3: AY, Quarter, Month and CY, Quarter_1, Month_1 will be active

I got the solution for case 1 from this thread :

How to sum across rows in a pivot table (running total)

but the moment i enable multiple dimension it fails(last image in my reply). It works for year = 2008 but not for year 2009,2010 and so on

Let me know if you need anything else

Regards,

Sagar Gupta