Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
this may be helpful!
you can use PEEK in script to obtain a new field with the previous amount.
I have been using formula
sum({<GL_Date = {'=QuarterEnd(AddMonths(Max(GL_Date), -3))'}, Balance)
Where Dimension is based on GL_Date
Hey Rajendra,
Is it possible to attach a sample source file(may be like in excel)
Thanks
AJ
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.