Changing the order of values in a dimension

[Anonymous]

I would like to change the order of values in a dimension.  I tried to use the following expression as my dimension and whilst they appeared in the correct order the values changes to '1', '2' and '3' rather than their normal names.

=Match([SSES_mode], 'Full-time', 'Part-time', 'Distance/Flexible')

Any suggestions?

Thanks

Greg

[Chanty4u]

try this

if(Match([SSES_mode], 'Full-time', 'Part-time', 'Distance/Flexible') ,[SSES_mode])

[devarasu07]

Hi,

Try like below,

=pick(Match([SSES_mode], 'Full-time', 'Part-time', 'Distance/Flexible'),1,2,3)

[stabben23]

Hi Greg,

what chart do you use? You can order Your Dimension in sort tab.

[Anonymous]

I managed to get this to work eventually using the following expression as my dimension

=Dual(Pick(Match(SSES_mode, 'Full-time', 'Part-time', 'Distance/Flexible'),
'Full-time', 'Part-time', 'Distance/Flexible'),
Match(SSES_mode, 'Full-time', 'Part-time', 'Distance/Flexible')) 

Thanks for your help.