Pivot how to sort latest date to 1 st column ?

[#1]

Hi All

I have below table i need to make the OCt 2013 latest date to 1 st column, any advise ?

[#2]

hi

try to use dual() function.

[Jason_Michaelides]

Is YearMonth a numeric field?

[#4]

Hi Paul,

You can try to change the change the way the field YearMonth is sorted.

[sathishkumar_go]

Hi Paul, Try sort by load order "Reverse". If u can attach the application, It will easy for us. Regards Sathish

[#6]

Hi All

Thank you for all your reply.

You can download my QV doc from below link :-

Dropbox - 000_QVD_v20398 ask sort.qvw

Paul

[#7]

Hi All

Pls ignore my previous post , you should download my QV doc from this post here.

[tresesco · Accepted solution]

Your YearMonth field is proper date, so no issues there; only sort order has to be right in combination.

PFA