Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Pick() takes a number value as its first argument.
U have given string type value.
what would be the right syntax then ?
Thanks for your reply