I have added a user defined field in the matrix of purchase order i.e TC.If the itemcode is 392042A04 or 392044A04 or 392049004 then Yes should be displayed in the column TC.For this I created query as,
select (case when charindex ($[$38.11],'HRPSAL0519,HRPGEN0593,BBAGEN0006,392042A04,392044A04,392049004,392057004,392070004,392072004,341023004') >0 then 'Yes' else 'No' END)
Later I created formatted search on the change event of itemcode.But it is not working.