Hi Folks,
Concerns regarding Pick match need your help.
Now we faced the challenge, See details as below:
Dimension:
Pick(match(GetFieldSelections(Periods),'Qtr','MAT','Monthly','YTD'
),
YearQtr,[Y e a r],YearMonth,Pastfield
)
Note:Passfield not associated with master table, other three dimension associated.
Measure:
Pick(match(GetFieldSelections(Periods),'MAT','Qtr','Monthly','YTD'),
num(sum(1),'#,##0'),
sum(2),
sum(3),
sum(4)).
In current case, we get the result as 1224, not 4; just we used Pastfield only, we can get the correct num 4, so this is my concern, why we cant get the correct num? Thanks in advance.
Best Regards,
Haifeng
