Values Show based on the month selection

[sat_tok52]

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.

[sunny_talwar · Accepted solution]

May be this

Sum({<MonthField, MonthYearField = {"$(=MaxString(MonthYearField ))"}>}Sales)

[Rohan]

Hey, I think you just need a basic MTD equation.

Sum ({<Date = {">=$(=Monthstart(max(Date))) <=$(=Monthend(max(Date)))"}>} Sales).

Thanks & Regards

Rohan S. Desai.