Issues in Pick Match function

[xavieravinson]

Hello All,

I am using pick match function to show some measures. For Eg. Region is my dimension. One of my region doesn't have values for current year but it has values for previous year. In normal expression it showing values for previous year but in pick match it is not showing any values.

Please help me to solve this issue.

With Regards,

Xavier

[VishalWaghole]

Could you please share some sample data with your problem.

[Channa]

try lookup or applyMap

[xavieravinson]

Hello All,

Attached the sample file. 

Want LY values in Pick Match.

With Regards,

Xavier

[xavieravinson]

Sample Application