I have been reading several discussion on this but unable to grasp the meaning of the formula used.
What i need is to create an automate dashboard that will update accordingly. Say today is Feb16. I would want the report to show the sales from Jan16 this year to Feb16 and compared with Same period last year. (Jan15 to Feb15)
I know i need to put some set time based modifier on this but not sure which best suit. either using addmonth function or dual function. What i know i need to use something like from and to as date today in the set modifier.
If anyone have any solution or links to this it will be greatly helps.
