Totals at bottom in a Subset

Post Reply
BigG
Community Contributor
Posts: 211
Joined: Tue Sep 15, 2009 11:13 pm
OLAP Product: IBMPA
Version: PA 2.0 Cloud
Excel Version: 2010

Totals at bottom in a Subset

Post by BigG »

hi, A predecesor has done some trickery to create a heirachy with the Totals at bottom of a subset groupings, How do I reverse this so it has totals at top of groupings.. must be a setting but I cannot find it... thanks in advance
GG
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Totals at bottom in a Subset

Post by Alan Kirk »

BigG wrote:hi, A predecesor has done some trickery to create a heirachy with the Totals at bottom of a subset groupings, How do I reverse this so it has totals at top of groupings.. must be a setting but I cannot find it... thanks in advance
In the Subset editor, View menu, check out the "Expand Above" setting.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
BigG
Community Contributor
Posts: 211
Joined: Tue Sep 15, 2009 11:13 pm
OLAP Product: IBMPA
Version: PA 2.0 Cloud
Excel Version: 2010

Re: Totals at bottom in a Subset

Post by BigG »

Wow, that was easy,thought it was a menu selection that button... cheers
GG
Post Reply