Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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