5 Replies Latest reply: Apr 17, 2017 5:08 PM by Justin Dallas RSS

    Ignore one fields selection, but process the others

    Justin Dallas

      Hello Everyone,

       

      I have a dashboard where I am using the YOY construct, i.e Sum({$<Year = {$(=max(Year)-1)}>} [Sales]) vs Sum({$<Year = {$(=max(Year)}>} [Sales]).  My problem is that when a user selects Year='2015', the years that satisfy the {Max(Year)-1} clause are excluded.  So to solve that, I've added the '1' to my analysis giving me this.

       

      Sum({1<Year = {$(=max(Year)-1)}>} [Sales])

       

      The only problem is that the '1' causes ALL selections to be ignored.  So when the user selects Quarter=1 or Month=January, it doesn't cascade through.

       

      How do I make my analysis ignore the year selection but use the calculation, and then apply any other user selections?