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?

Image

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