2 Replies Latest reply: Mar 23, 2013 4:23 AM by jagan mohan rao appala

# Current Years Current Month Vs Last Year Same Month Sales

Hi All,

I am getting problem in calculating last Year Month Sales on Selection,

I have tried two set expression for that but in both the cases my expression working only when I am not selecting anything, If I select anything then it wont show any data. I am also attaching Sample Data.

eg.

Please provide any alternative for that.

Thanks & Regards,

Nirav Bhimani

• ###### Re: Current Years Current Month Vs Last Year Same Month Sales

Hi Nirav,

Please find here the attached file for the solution of your issue.

Regards,

Udit

• ###### Re: Current Years Current Month Vs Last Year Same Month Sales

Hi Nirav,

Use this expression for

Current Year Current Month

=Sum({<CalYear=, CalMonthYear=, CalMonth=, CalQuarter=, CalDate={'>=\$(=MonthStart(Max(CalDate)))<=\$(=MonthEnd(Max(CalDate)))'}>} Sales)

Last Year Current Month

=Sum({<CalYear=, CalMonthYear=, CalMonth=, CalQuarter=, CalDate={'>=\$(=MonthStart(Max(CalDate), -12))<=\$(=MonthEnd(Max(CalDate), -12))'}>} Sales)

Hope this helps you.

Regards,

Jagan.