I have a calculated dimension if(Year = 'Current', [Current Course Age], [Previous Course Age] ) and I have labeled it as Course Aging.
The possible values under Current Course Age], [Previous Course Age] are
"1-2 Years Old"
"3-4 Years Old"
">=5 Years Old"
I want to be able to sort the calculated dimension in the order mentioned above.
Edit:Also, the Values have quotes in them.
Still does not work. I am using
=WildMatch(if (Year= 'Current' ,[CurrentCourseAgeDescription],[Previous Course Age Description]),'*First Run*', '*1-2 Years Old*','*3-4 Years Old*', '*>=5 Years Old*')
Hahahaha this is not what I asked for.... Would you be able to share a qvw app or may be some raw data?