Sort by Month and Year in the Sort pane of calculated dimension in straight table

[#1]

I have a calculated dimension in straight table:

=IF(Year>2009, IF([Product Type]='Sales',IF(MasterCodeDesc = 'BASE', Year & '-' &

pick(match(UPPER(Month),'JAN','FEB','MAR','APR','MAY','JUN', 'JUL','AUG','SEP','OCT','NOV','DEC'), '01','02','03','04','05','06','07','08','09','10','11','12'), Null()),Null()),Null())

and I would like to sort this dimension by Year then Month.

I tried this:

which seems not work...

many thanks in advance

[mahesh_agrawal]

Hi,

Pick() takes a number value as its first argument.

U have given string type value.

[#3]

what would be the right syntax then ?

Thanks for your reply