Page 1 of 1

dynamic subset for last 5

Posted: Fri Sep 22, 2017 7:50 am
by raman
i wan to make a dynamic subset using expression which shows last 5 elements of dimension.
i used this

{drilldownlevelbottom({[segment].[all segments]},5)}

but this one is showing first 5.

Re: dynamic subset for last 5

Posted: Fri Sep 22, 2017 8:14 am
by Wim Gielis
The last 5 elements of a dimension, or the last 5 children/descendants ?

If the former:

{Tail( TM1SubsetAll( [segment] ), 5 )}

If the latter, I'll leave it as an exercise for you.