How do i rearrange my valuelist

[oehizele]

=ValueList(
'1',
'3',
'',
'4',
'6',
'5'
)

i want my pick(match(valuelist(...),),) to follow that format above but it keeps rearranging to '',1,3,4,5,6 on my report.How do i default it to the above placement?

[fosuzuki · Accepted solution]

Hi

Go to the Chart Properties > Sorting > expand the valuelist dimension, choose custom sorting, sort by expression, and add this expression:

=match(ValueList( '1', '3', '', '4', '6', '5' ), '1', '3', '', '4', '6', '5' )