how to apply the filters to metric in variable level

[Anonymous]

hi Team,

Good Day

...i working around one issue but i am not able find exact solution

here my issue'

i have one metric like "mTotalSal"

and i have 2 filters  like -------abc=1      ,         cdf=0

now i need to filter out the metric values using above filters in variable level only

like

<Mtotalsal>,abc=1,cdf=0

note:A comma separated list of Boolean expression or a table expression that defines a filter

--out put:

metric is must satify the filters abc=1,cdf=0 .

and after satisfying  that filters then  i want  to sum of metric value

like in variable level  i need to create this filterd metric

Can any one suggest better way

Thanks,

Bobby

[Gysbert_Wassenaar]

sum({<abc={1},cdf={0}>}mTotalSal)

[Anonymous]

Thanks Gysbert Wassenaar 

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

please suggest me suitable matching code

Regards,

Boby

[Gysbert_Wassenaar]

ABC is not abc. Use case sensitive field names. sum({<ABC={1},CDF={0}>}mTotalSal)