Hi
I am using the following expression in one of chart for sorting the dimension. The problem what I am facing here is that whenever I select 2011 it is not getting sorted properly but for the rest of the years it is getting sorted properly. One of the possible reason for this may be because 2011 contains only one period(A1).
Can some one please check and let me know what could be done with this expression. For your understanding, A1,A2,...,A12 are months only which is named like this.
For your information A1-A12 are months only it is calculated in script.
Expression:
=wildmatch(PERIOD,'A1','A2','A3','A4','A5','A6','A7','A8','A9','A10','A11','A12')
When selecting 2011 sorting in proper may be because it contains only one period(A1):
'A1','A10','A11','A12','A2','A3','A4','A5','A6','A7','A8','A9'
When I select other years(2010,2009) sorting is proper as shown below. May be because it contains all the period(A1-A12)
'A1','A2','A3','A4','A5','A6','A7','A8','A9','A10','A11','A12'
