order by year

[#1]

Hi, currently I have this:

How can I make it such that it is ordered by year? meaning 2013 on top. Thanks.

[selvakumarsr]

In Sort tab..In Expression (=Year) and  select Ascending

[MK_QSL · Accepted solution]

Go to Sort tab

Expression

DUAL(Date#(SummaryMonth,'M/YYYY'),Date(Date#(SummaryMonth,'M/YYYY'),'YYYYMM'))

[alexandros17]

In the sort tab check only expression and write:

=Right(myField, 4) & Num(Mid(1,index(myField, '/')-1),'00')

where myField is the field you have used

let me know

[sujeetsingh]

The correct way use expression sorting