Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Nirav,
Please find here the attached file for the solution of your issue.
Regards,
Udit
Hi Nirav,
Please find here the attached file for the solution of your issue.
Regards,
Udit
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.