How to ignore filed selection while using Pick(Match())

[lakshman1031]

Hi All,

I have pivot table and i am using multiple pick(Match()) functions and i am trying to ignore the field selection, but it is not ignored. I am using below expression. I am trying to ignore Subcategory

If(Only{<Subcategory=>}Region)='Central',

(Pick(Match( Only{<Subcategory=>}Category, Categ1,Categ2),

Sum({<Year={Max(Year)},Category={'Categ1'},Subcategory=>}Sales),

Sum({<Year={Max(Year)},Category={'Categ2'},Subcategory=>}Sales))),

If(Only{<Subcategory=>}Region)='East',

(Pick(Match( Only{<Subcategory>}Category, Categ3,Categ5),

Sum({<Year={Max(Year)},Category={'Categ3'},Subcategory=>}Sales),

Sum({<Year={Max(Year)},Category={'Categ5'},Subcategory=>}Sales)))

)

I am trying to restrict field selection, but it is not working.

Can you please suggest me how to restrict field selection when using if condition and pick(Match()) function.

Thanks & Regards,

Lakshman

[Qrishna]

1. Maybe syntax error: Only{<Subcategory=>}Region) --->  Only({<Subcategory=>}Region))

2. try using  : If(Aggr(Only({<Subcategory=>}Category), Fields) ='Central',  ....)