Reg-condition display

[#1]

Hi Team ,

we created a straight table and in that we have different filters in the right side of the chart. we have filters like organisation,productyear.

in organisation we have fields like BU,ZONE,RSM.

if we select BU=CI and year =2015 and brand=essentiale then EH should come .

now we have diff products in the product filter.

Now if i select BU=CI and year =2015 and brand =Essentiale and product=Essentiale inj. This should be changed from BU=EH and product=Essentaile cap

i have wriiten condition lie this.

=if(BU='CI' and Year>=2014 and Brand='Essnetiale','Essnetiale inj','Essentiale cap') now its ok But the problem is if i give this condition iam getting EH and i aslo getting another bu like pc.

This PC SHOULD NOT COME ONLY EH SHOULD BE APPEAR

CAN ANY ONE HELP ME OUT.

[sujeetsingh]

You can use a select on trigger for this field and use an action "Select in Field"

[Siva_Sankar]

Can you share the application?

[#4]

=if(BU='CI' and Year>=2014 and Brand='Essnetiale','Essnetiale inj','Essentiale cap') for this condition iam getting EH.But PC IS ALSO COMING. I WANT TO HIDE PC.

CAN U PLEASE SUGGEST IN WRITING ANY CONDITION HERE ITSELF