Custom sort?

[gauravgg]

Hi all

I have a field as follows

PricePointer

17-Budget

18-Budget

17-Sept

17-May

16-Budget

17-Opening

17-Colsing

I want to custom sort this on x axis

16-Budget

17-Budget

17-Opening

17-Closing

17-Sept

17-May

18-Budget

Can anyone help me

thanks in Advance

[shraddha_g]

In sort by Expression

Try,

pick(wildmatch(PricePointer,

'16-Budget',

'17-Budget',

'17-Opening',

'17-Closing',

'17-Sept',

'17-May',

'18-Budget'),1,2,3,4,5,6,7)

[gauravgg]

Hi Shraddha

but this sort should be dynamic

it should sort by Year  then the order should bb Budget ,Opening,Closing,and within months it sholud sort by Month(As jan to Dec in order)

[shraddha_g]

did you try checking numeric & Alphabetic to ascending order?

[gauravgg]

yes i tried,

it is not working

[shraddha_g]

can you share sample app?

[gauravgg]

no ,it's on server

I do not have rights

[vinieme12]

Two Options either sort by expression using Match(  or create a sortOrder for this field in script

Option1: example

PricePointer_SortOrder:

LOAD * INLINE [

PricePointer, PP_SprtOrder

16-Budget,1

17-Budget,2

17-Opening,3

17-Closing,4

17-Sept,5

17-May,6

18-Budget,7

];

Then in Chart use sort by expression and add  =PP_SprtOrder

Option 2:

Sort by Expression

=Match(PricePointer,

'16-Budget',

'17-Budget',

'17-Opening',

'17-Closing',

'17-Sept',

'17-May',

'18-Budget')

[shraddha_g]

Check