4 Replies Latest reply: Oct 8, 2015 11:22 AM by Sunny Talwar RSS

    Count if Distinct with a Set Modifier

    Joanna Seldon

      Hiya

       

      have a expression like this

       

      count ( distinct  if([Target]<'35', Check_Number))

       

      but  I want to add a set Modifier to it

       

      I want to exclude customers from e.g  a country America

       

      how would I please add this {$<[Country] ={"America"} >}

       

      I try but my bars still shows for America as 0, but I want it to not appear

       

      Kind Regards