4 Replies Latest reply on May 21, 2018 11:27 AM by Deepak Rai

    Set is not reflecting inside the Filter

    sonam jha

      Hi All,

       

      I am trying to filter customer name based on a condition.So when sales is >40000 then give me relevant customer name and want to use those customer name as as filter value.

      In short, the values in the report and values inside the filter should be the same(where i will have only >40000 list of customers).

       

      I tried following but did not work :

       

      1) I have created Customer Name set based on formula (sum(sales) >40000) ,However when i drag this set into filter i am not getting the customer name based on formula,instead getting all customer Name.

      2) I did try Include option( Include customer Name: sum(sales).>40000)- it works when i drag and drop into filter,Issue is i am not getting list of customer name here based on formula.

       

      Any help would be appreciated.

       

      Thanks in advance.