I have a YTD report that automate on a monthly bases based on YTD that runs on the 9th of each month. In the report the YTD is offset by 7 days therefore the numbers in the report will always be from the beginning of the year 01/01/2018 - 02 of each month driven by Day selector.
I now have a new requirement to produce a new column that displays YTD previous month. Example below.
Report runs on 9th Nov.
Current YTD: Data shows from 01/01/2018 - 02/11/2018 - Value: 200...
Required new column YTD Previous Month: 01/01/2018 - 02/10/2018 - Value: 100...
The next report will be the 9th Jan 2019 and the date rage will be as follow.
YTD: 01/01/2018 - 31/12/2018
YTD PM: 01/01/201/ - 02/12/2018
Can you advise how I can do this dynamically without having to hardcode the cude and change it on a monthly bases.