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
we have 5 tabs in this application.for 1-4 tabs id i write this condition.=if(BU='CI' and Year>=2014 and Brand='Essnetiale','Essnetiale inj','Essentiale cap') now its ok .but this should not reflect for 5th tab. for 5th the selections should be done only for year=2015
Can anyone please help me
