13 Replies Latest reply: Feb 19, 2018 11:36 AM by Carlos Londono RSS

    Search Expression

    Tal Sibony

      Hi All ,

       

      I have table with 3 dimensions:

       

      Month

      Client

      Country

       

      And 2 measures:

       

      Sales

      Number of products

       

      Let's say i have 100 rows in this table.

      Each row contains specific match and the numbers are different.

       

      Now i have chosen  the current month.

      I would like to use the search expression in the Country column to filter sales above 200,000$.


      When i use =sum(Sales)>200,000 it shows the total per country meaning sum of all combinations that above 200,000$ but it is not what i would like to get.


      How can i use the search expression the get all combinations in the table using the existing dimensions to get sales>200,000$.


      For example :


      Client a          FR        203,456$

      Client b          DE        567,999$

      Client c          US        900,233$

       



      And not :


      Client a          FR        203,456$

      Client b          DE        567,999$

      Client c          US        900,233$

      Client d          FR        115,745$


      Client d should not be in the selection.




      Best,

      Tal