Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?
Any suggestions or work around?
Cheers.
Adriano.
May be this:
Sum({<Date = {"$(='>=' & Date(MonthStart(Today(), -1), 'DateFieldFormatHere') & '<=' & Date(MonthEnd(Today(), -1), 'DateFieldFormatHere'))"}, Month, Year, MonthYear>}value)
Thanks Sunny, that was exactly it!
Cheers and thanks again for the help.