Hi Guys
Silly Question - how do you set subset to expand above when you click on it?
Many thanks!!
Regards
Chris
Pax - Expand Above
- Steve Rowe
- Site Admin
- Posts: 2415
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Pax - Expand Above
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.
Make sure the set editor is in to Hierarchy mode rather than definition mode as well as this (might) make a difference too.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Posts: 13
- Joined: Tue Dec 06, 2016 11:24 am
- OLAP Product: TM1
- Version: 10.3.0
- Excel Version: 2010
Re: Pax - Expand Above
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?
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?
- gtonkin
- MVP
- Posts: 1198
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Pax - Expand Above
TM1RptRow has a parameter to expand above. Try set it and see if that helps. Remove the expand mode from the MDX string too.
-
- Posts: 13
- Joined: Tue Dec 06, 2016 11:24 am
- OLAP Product: TM1
- Version: 10.3.0
- Excel Version: 2010
Re: Pax - Expand Above
Ah, I didn't know about that parameter.
Thanks George
Thanks George