Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Sum({1<Year={1998},Quarter={'Q1'},Month={'Mar'}>} LineSalesAmount)
Sum({1<Year={1998},Quarter={'Q1'},Month={'Mar'}>} LineSalesAmount)
Thank you! That works perfectly. Still learning syntax .
Take good care,
Scott