How to get previous month balance

[#1]

Hi All

I have Pivot table as below

   Qtr ->                 Q4 2012         Q1 2013      Q2 2013       Q3 2013

Begin Period               ???                 105             400              224

End Period                   105                 400             224              156

Previous Month    9/30/2012      12/31/2012    3/31/2013     6/30/2013

The "End Period" is Begin period of next quarter, How do I get these "Begin Period"?
For Q4 2012 Begin Period is Balance from 9/30/2012 (GL_Date)

Your helps are appreciated, Thanking you lot

[Anonymous]

this may be helpful!

How to get previous value on straight table?

[#3]

you can use PEEK in script to obtain a new field with the previous amount.

[#4]

I have been using formula

sum({<GL_Date = {'=QuarterEnd(AddMonths(Max(GL_Date), -3))'}, Balance)

Where Dimension is based on GL_Date

[#5]

Hey Rajendra,

Is it possible to attach a sample source file(may be like in excel)

Thanks

AJ

[#6]

You can use Above function to get the previous values in the UI level.

=Above([Begin Period]) may work...be sure you order by Quarter field.