TM1 Forum

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,

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

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

I'm talking about the subsets themselves, not the elements...

erik664 wrote:[I'm talking about the subsets themselves, not the elements...

No.

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."

You could try prefacing the month name with the code, 01-Jan, 02-Feb,...