2 Replies Latest reply on May 11, 2017 10:41 AM by Andrew M

    Dynamic Reference Filtering on "All"

    Andrew M

      Hello, this should be an easy one but can't seem to find the exact answer on the community. I'm looking to create a dynamic reference line based on a filter. I can do this when selecting the options from the filter. However, I can't seem to get the reference line to update when "All" is selected on the filter. Attached is a sample workbook.

       

      I would like my "Goal" reference line to update based on the filter selection in the following way:

      Exclude="No" Then 12

      Exclude="Yes" Then Null

      Exclude="All" Then 15

       

      Thank  you kindly for your help.