1 Reply Latest reply: Mar 2, 2017 1:15 PM by Gysbert Wassenaar RSS

    How do I exclude field names based on associations with other field names?

    Ricky Scheiber

      Within my chart (heat map) I want to use something like this to exclude names from a specific field. In this case, I don't want anything associated with 'Performance' to appear. I used this for a bar chart: 

       

      IF ( [ Managed Section ] ) < > 'Performance' , [ Managed Section ] )  ... in this case, 'Performance' is an element of the 'Managed Section' field. 

       

      Now, what I want to add to this. I don't want any names from a separate field - User Name - that are associated with 'Performance' under Managed Section to appear in a heat map.

       

      How do I create this so that I exclude any rows that are associated with 'Performance'?