Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a KPI is Sum(Sales),As per my requirement my KPI should show if it is in clear all position the KPI value should show current month data.If user selected any month the value should show based on the selected month ,if user click on clear all it should be back to current month data any help.
Thanks.
May be this
Sum({<MonthField, MonthYearField = {"$(=MaxString(MonthYearField ))"}>}Sales)
May be this
Sum({<MonthField, MonthYearField = {"$(=MaxString(MonthYearField ))"}>}Sales)
Hey, I think you just need a basic MTD equation.
Sum ({<Date = {">=$(=Monthstart(max(Date))) <=$(=Monthend(max(Date)))"}>} Sales).
Thanks & Regards
Rohan S. Desai.