Current Month Vs Last Month

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have Current Year Vs Previous Year(2018 Vs 2017) KPI with expressions like below.

Current Year  = Count({<Year = $(=Max(Year))}>}ID)

Previous Year = Count({<Year = $(=Max(Year)-1)}>}ID)

here we have one more filter like Month first user will filter year suppose if he selects 2017 then kpis is showing 2017 vs 2016 after that if he filter Feb on Month filter it has to show 2018 Feb Vs 2017 Jan.

Please let me know is this possible to implement in Kpi.

Thanks in advance.

[Anonymous]

Hi,

Perhaps something like this:

     Current Year  = Count({<Year = $(=Max(Year))}>}ID)

     Previous Year = Count({<Year = $(=Max(Year)-1)}, Month = {$(=max(period)-1)}>}ID)