Pick/ Match Concerns

[zhaohaifeng]

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

[big_dreams]

Hi,

Since we are not aware of your data model ,structure so we are unable to why it is going wrong?

Can you share your qvf? or provide more details?

Regards,

[zhaohaifeng]

Thanks. let me attached the qvf.