Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
My monthly reports report on previous month, so i need a variable to pick up the last month and then combined last three months. My fields for Year and Month are set up like below. So for current report i'll need Sales Month 12,11,10 and Sales year 2015.
Thanks for your help guys
Sales Year | Sales Month |
2015 | 1 |
2015 | 2 |
2015 | 3 |
2015 | 4 |
2015 | 5 |
2015 | 6 |
2015 | 7 |
2015 | 8 |
2015 | 9 |
2015 | 10 |
2015 | 11 |
2015 | 12 |
2016 | 1 |
Hi Lak,
I can see that you are trying to create a master calendar:
Follow this and this should solve your issue:
Thanks,
Sangram.