Page 1 of 1
Pax - Expand Above
Posted: Tue May 26, 2020 10:21 am
by chewza
Hi Guys
Silly Question - how do you set subset to expand above when you click on it?
Many thanks!!
Regards
Chris
Re: Pax - Expand Above
Posted: Tue May 26, 2020 11:07 am
by Steve Rowe
In the set editor toggle the Show Totals Leading / Trailing which is the Epsilon with the bars above and below it in the middle of the editor.
Make sure the set editor is in to Hierarchy mode rather than definition mode as well as this (might) make a difference too.
Re: Pax - Expand Above
Posted: Thu Jul 14, 2022 2:09 pm
by Keith Would
Hello
I've looked at this thread as well.
https://www.tm1forum.com/viewtopic.php?t=14451
The TM1ToggleExpandMode seems to stop the dynamic formatting working in a Dynamic PAfE report, making all roll ups be Level 0?
In this case, at the bottom,
5 Total Interest... is actually a Level 1
5100 Interest... is actually a Level 2
Also, you can still click on the + signs, and they then expand below??
Am I missing something?
Re: Pax - Expand Above
Posted: Thu Jul 14, 2022 4:11 pm
by gtonkin
TM1RptRow has a parameter to expand above. Try set it and see if that helps. Remove the expand mode from the MDX string too.
Re: Pax - Expand Above
Posted: Fri Jul 15, 2022 2:17 pm
by Keith Would
Ah, I didn't know about that parameter.
Thanks George