custom sorting on last 12 months

[grajmca_sgp123]

hi,

How do we sort last 12 months in bar chart.

ex:

201409

201410

201411

201412

201501

201502

'

'

'

thanks

[sunny_talwar]

May be use Expression to sort it ascending or descending and expression would be:

Date#(YearMonthFieldName, 'YYYYMM')

[maxgro]

in sort tab and sort by text or number

or if you want a custom order in expression

wildmatch(yourfield,201409,201410,........,'*')