YearQtr unable to display from left to right

[paulyeo11]

Hi All

I have a script that generate Yr Qtr , it work fine :-

Right(year(date),2) & '-Q' & ceil(Month(date)/3)                                                                        as [YearQtr],

But today i want my chart latest date start from left side , and i notice that it is not able sort from Hi to Lo.

Hope some one can share with me how to change the above script ?

PAul

[paulyeo11]

Hi Sokkom

Now i am confuse. because i use your chart copy and paste to my Doc again it does not work.

This only happen on my this QV Doc. i also have other QV Doc which is running fine with out add any expression at sort .

You have any idea how to make quart like year and yearmonth ?

Paul