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.
dynamic subset for last 5
-
- MVP
- Posts: 3128
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: dynamic subset for last 5
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.
If the former:
{Tail( TM1SubsetAll( [segment] ), 5 )}
If the latter, I'll leave it as an exercise for you.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly