Custom dimension based on Selection of Type of Calendar

[nishika]

Dimension:

=Pick(Match([Type Of Calendar],'Season Calendar','Fiscal Calendar'),

Valuelist('Nov'&'$(v_PrevioustoPrevious_Year)'&'-'&'Mar'&'$(v_Previous_Year)'&' Orders',
'Nov'&'$(v_PrevioustoPrevious_Year)'&'-'&'Mar'&'$(v_Previous_Year)'&' Rejected Orders',
'Nov'&'$(v_Previous_Year)'&'-'&'Mar'&'$(v_Current_Year)'&' Orders',
'Nov'&'$(v_Previous_Year)'&'-'&'Mar'&'$(v_Current_Year)'&' Rejected Orders',
'Nov'&'$(v_Previous_Year)'&'-'&'Oct'&'$(v_Current_Year)'&' Orders',
'Nov'&'$(v_Previous_Year)'&'-'&'Oct'&'$(v_Current_Year)'&' Rejected Orders'),
Valuelist('Jan'&'$(v_Previous_Year)'&'-'&'May'&'$(v_Previous_Year)'&' Orders',
'Jan'&'$(v_Previous_Year)'&'-'&'May'&'$(v_Previous_Year)'&' Rejected Orders',
'Jan'&'$(v_Current_Year)'&'-'&'May'&'$(v_Current_Year)'&' Orders',
'Jan'&'$(v_Current_Year)'&'-'&'May'&'$(v_Current_Year)'&' Rejected Orders',
'Jan'&'$(v_Current_Year)'&'-'&'Dec'&'$(v_Current_Year)'&' Orders',
'Jan'&'$(v_Current_Year)'&'-'&'Dec'&'$(v_Current_Year)'&' Rejected Orders')
)

This is giving invalid Dimension.

Although,

=Pick(Match([Type Of Calendar],'Season Calendar','Fiscal Calendar'),1,0) is working fine as Dimension

[nishika · Accepted solution]

As an Alternate Solution,

Created two charts one for season and other for fiscal

Put them in container

and apply show condition based on selection