AnsweredAssumed Answered

YTD Previous Month by day

Question asked by minh.doan on Dec 17, 2018
Latest reply on Jan 11, 2019 by minh.doan



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.


Many thanks