Is there any way to rearrange the order of subsets besides the default alphabetical sort?
I've created subsets of elements for a dimension where the elements correspond to a certain month, so the subsets are named after months. But when sorted alphabetically, it puts 'April' first. Is there any way to change the order? I know I could get around this by prefixing the subsets with the number of the month, but I was just wondering if there was another way.
Thanks,
Order of Subsets
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: Order of Subsets
Several....
Sort by index
Write MDX to get the order you want
Write TI to get the order you want
Copy/Paste (including in and out of Excel)
Drag and Drop

Sort by index
Write MDX to get the order you want
Write TI to get the order you want
Copy/Paste (including in and out of Excel)
Drag and Drop
-
- Posts: 18
- Joined: Fri Mar 08, 2013 6:11 pm
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: 2007
Re: Order of Subsets
I'm talking about the subsets themselves, not the elements...David Usherwood wrote:Several....![]()
Sort by index
Write MDX to get the order you want
Write TI to get the order you want
Copy/Paste (including in and out of Excel)
Drag and Drop
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Order of Subsets
No.erik664 wrote:[I'm talking about the subsets themselves, not the elements...
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Order of Subsets
Dorothy Parker, seated next to Calvin Coolidge at a dinner, said to him, "Mr. Coolidge, I've made a bet against a fellow who said it was impossible to get more than two words out of you." His famous reply: "You lose."
- wissew
- Posts: 54
- Joined: Tue Jun 17, 2008 7:24 pm
- OLAP Product: TM1
- Version: 9.5.2; 10.2.2; 11
- Excel Version: 2003 SP3 - 2013
- Location: Beaverton, OR
Re: Order of Subsets
You could try prefacing the month name with the code, 01-Jan, 02-Feb,...