2 Replies Latest reply: Dec 8, 2017 3:47 PM by Scott Allen RSS

    Static KPI

    Scott Allen

      I am trying to have a static KPI that is not influenced by filters selected in the app.  I'm not sure of the syntax that I need to use Year, Quarter, and Month as the filter.  This format is adding them all together when filters are selected.  When all is unfiltered, the answer is correct:


      Sum({$1<Year={1998}>+$1<Quarter={"Q1"}>+$1<Month={"Mar"}>} LineSalesAmount)