Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)))