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

    Count if Distinct with a Set Modifier

    Joanna Seldon



      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