6 Replies Latest reply: Jan 21, 2015 5:24 PM by Joe Crane RSS

    Need Only selected year to show up

    Joe Crane

      I need (through set analysis) to show selected years or months on this chart depending what the user selects:

       

      for example, when they select a year of 2014, I would only like the red line to show up. if they pick two months (i.e. Jan-Feb), along with 2014, I want to see the red line only for those two months.

       

      The equations I have right now for the three expressions are as follows in descending order of year:

       

      • sum({$<Year= {$(=Year(Today()))}>} MembershipFlag)
      • sum({$<Year= {$(=Year(Today())-1)}>} MembershipFlag)
      • sum({$<Year= {$(=Year(Today())-2)}>} MembershipFlag)

       

      Any help on this is greatly appreciated.

       

      Thanks,

       

      Joe