Sort for GetFieldSelections() dimension

[zhaohaifeng]

Dear all,

As we want to used GetFieldSelections() fuction to judge the dimension, but if we used GetFieldSelections(), for sort we used the specific field, it's not useful.

As per test, if we used the specific field in the dimension the sort works. So all, who can help me how to set sort for GetFieldSelections() fuction.

Sort not works :

Dimension:

=Pick(Match(GetFieldSelections(Periods),'Quarter','MAT','Monthly','YTD'),

YearQtr,

[Y e a r],

YearMonth,

null()

)

Sort:

if(GetFieldSelections(Periods)='Qtr',YearQtr,if(GetFieldSelections(Periods)='MAT',[Y e a r],

IF(GetFieldSelections(Periods)='Monthly',YearMonth)))

Sort work:

Dimension:

YearMonth

Sort:

Sort:

if(GetFieldSelections(Periods)='Qtr',YearQtr,if(GetFieldSelections(Periods)='MAT',[Y e a r],

IF(GetFieldSelections(Periods)='Monthly',YearMonth)))