Set filter value and ignore any other selections...
Need help in figuring this out.
I have a normal KPI showing the a Sum(value), and what I am trying to do, is set the Sum(Value) to show only for the previous month / current year, but at the same time, ignore if the user changes the Month or Year filter.
How do I enter the setin the expression to simultaneously "force" month and year, and then tell it to ignore the filters? Is this possible even?