Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Have a KPI that says
Sum({<Year={2018}>}Sales)
And a filter of Years (2016,2017,2018).
When I select Year 2017. I expect to see a 0 in the KPI but it still shows a number.
Can anyone explain.
The set expression overrides your user selection. This is the normal/default behaviour. You can override this to create an intersection between the selection and the year in the set expression, like this
Sum({<Year *= {2018}>}Sales)
The set expression overrides your user selection. This is the normal/default behaviour. You can override this to create an intersection between the selection and the year in the set expression, like this
Sum({<Year *= {2018}>}Sales)
Read more on this topic here: