3 Replies Latest reply on Feb 12, 2016 2:45 PM by Shinichiro Murakami

    Making a static line change

    David Lomascolo

      Ok so I have static averages in my chart (which I want). The problem is I don't know how to make those static lines change when I filter for year. For example, the static line in the screen shot below represents 2013 and 2015 % positive combined. Which is fine. But I know that when I filter for ONLY 2013, the static line average should change, but it doesn't. What do I need to adjust in my formula to do this? I have screenshotted my chart and the formula.

       

      Thanks!!