Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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?
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' )
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' )