3 Replies Latest reply on May 2, 2017 6:01 AM by tish.fernandes

    How can I exclude a dimesion1 value in the view based onn dimension 2 value?

    tish.fernandes

      I have two fields

      1. Company

      2. Status

       

      If the value of the 'status' field is 'bad' for a company, I want that company excluded from the view. Pls note the 'status' of a company can be good/bad/good and bad. I got this via  a calc - 'Good Companies'. Is what I did the right way to do it or are there better ways?

       

      One limitation with the above calc is if I bring the 'status' field into the view all the companies show up and not just the 'good'  ones.

       

      Thanks.