Sorting by monthyear error

[bushpalaamarnat]

Hi every one,

Could any one advise how to sort month year option as i have been facing problem with Jan 2017 and Jan 2018. No matter what selection was made in sorting these two months are showing at the end. Please refer the screen shot for better understanding.

Could some one help.

[olivierrobin]

hello

you should have a field in which the date is stored in format YYYYMM and sort on this field

you may also use dual to associate this value with the content of the field used in your graph:

i mean dual(field used in your graph, date in format YYYYMM) as .....

[bushpalaamarnat]

Hi, thank you for your response. the month and year is in text format, using your funtion i tried doing =dual(MonthYear,Date('MMMYYYY')) and it did not work, is there something else to do?

attaching the format for reference.

Kindly advise.

[sasiparupudi1 · Accepted solution]

Try this expression in the sort tab

Date(Date#(MonthYear,'MMMYYYY'))