Monthly Rolling data...

[#1]

Hello Experts,

A genral Query: In a Pivot, I have YearMonth  as Dimension which is in the format of 2011-01, 2011-02 and so on. I have a Amount Collected This month expression column which is a combination of 2 variables $(vAmount)+$(vInterest). Now I need to do a rolling yearly calculation for the field Amount Collected To Date, which is the sum of previous months amounts... rolling.

Thanks in Advance

[#2]

Hard for me to say exactly without looking at your example, but here is an exmaple of how I get cumulative amount billed in one of my applications:

=rangesum(above([Commercial Billed],1,rowno()))+[Commercial Billed]

Hopefully if you just take out commercial billed and put in amount collected to date, it will work

Edit: this assumes your data is sorted from oldest to newest