Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
if(Match([SSES_mode], 'Full-time', 'Part-time', 'Distance/Flexible') ,[SSES_mode])
Hi,
Try like below,
=pick(Match([SSES_mode], 'Full-time', 'Part-time', 'Distance/Flexible'),1,2,3)
Hi Greg,
what chart do you use? You can order Your Dimension in sort tab.
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.