4 Replies Latest reply on Nov 23, 2016 9:06 AM by Joe Oppelt

    How to apply filters to only ONE part of a calculated field?

    Jagdeep Bhogal

      Hi all

       

      I have a set of data that I'm applying 2 filters to (life stage and model of car driven).

       

      I also have the following calculated field:

      On one of my worksheets, I am filtering the data (that is created using this calculated field) by the above 2 filters. However, it seems the filter is applying to both of the elements within the calculated field, but I only want it to apply to one of the elements.

       

      Does anyone know how I can apply the 2 filters ONLY to [% of Sales Count] but NOT to [% of Population] within this calculated field?

       

      Thanks

       

      Jag