Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
did you try checking numeric & Alphabetic to ascending order?
yes i tried,
it is not working
can you share sample app?
no ,it's on server
I do not have rights
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')
Check