get the last three fiscal years using dimensional function

[Manu0521]

Hi I have a Time dimension and my members look like this.

I have All Fiscal year members as the top member,below which I have fY2005, fy 2006,until fy2014. I wanted to display last three completed  fiscal years- fy 2011,fy2012,fy2013.

How to achieve this

Thanks,

[Manu0521]

Last periods(2,2015) gives 2015,2014. I need 2014,2013.

[MFGF]

Last periods(2,2015) gives 2015,2014. I need 2014,2013.

Am I missing some obvious problem? What results do you get if you use lastPeriods(2,[your 2014 year member])

Isn't this just a logical progression from what you have? Or am I missing something obvious (which is quite normal for me) :)

MF.

[Manu0521]

No, lastperiods(2, X)

is the last child of a member. say my last child is 2014,'

my expression would be lastperiods(2,lastchild(member))
lastchild(member) would give me 2014.

I need to display only 2013, 2012.

The above result is giving me 2014 and 2013.

Thanks

[MFGF]

No, lastperiods(2, X)

is the last child of a member. say my last child is 2014,'

my expression would be lastperiods(2,lastchild(member))
lastchild(member) would give me 2014.

I need to display only 2013, 2012.

The above result is giving me 2014 and 2013.

Thanks

Oh - I see :)

What about

lastPeriods(2,prevMember(lastChild([member])))

MF.

[srinu_anu2007]

Hi,

Try to use the below expression and use MUN from the current year(2014) and the output would be 2014,2013,2012

lastPeriods(3,#'[P.Nam].[Dim.Name].[Hierarchy Name].[Year]->:[TM].[Dim.Name].[Hierarchy Name].[@MEMBER].['+timestampMask($current_timestamp,'yyyy')+']'#)