Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
salleninsd
Creator
Creator

Static KPI

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)

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

Sum({1<Year={1998},Quarter={'Q1'},Month={'Mar'}>} LineSalesAmount)

View solution in original post

2 Replies
petter
Partner - Champion III
Partner - Champion III

Sum({1<Year={1998},Quarter={'Q1'},Month={'Mar'}>} LineSalesAmount)

salleninsd
Creator
Creator
Author

Thank you!  That works perfectly.  Still learning syntax .

Take good care,

Scott