Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have data from 2007 to 2012, whenver i will select any month from any year i want update the sheet with selected month and previous month....so how can we use the set analysis here...
Hi Anil,
Check this expressions
For Previous Month
=Sum({<Year=, Month=, DateOfService={'>=$(=MonthStart(Max(DateOfService), -1))<=$(=MonthEnd(Max(DateOfService), -1))'}>} Sales)
For Current Month
=Sum({<Month=, Year=,DateOfService={'>=$(=MonthStart(Max(DateOfService)))<=$(=Max(DateOfService))'}>} Sales)
Hope this helps you.
Regards,
Jagan.
Hello,
See the example in the file attached.
Regards,
David