II have tried the formula that you suggested. however i am not getting required result. i am supposed to get 15% but i am getting 20%. looks like filters ABC = 1& CDF = 0 are not working. when i made filtered as needed I was getting 15%. kindly look into this.
Here bellow you can see with out filter
now you can see with filter data
here i want to create all the above filters in variable only