I want to build the QTD logic by accumulating the MTD values..MTD values are stored in the QVD..I want to fetch the month end of each month (Say for example - for Q1 2021- Jan 31,Feb 28,Mar 31 values should be added for QTD).How can I achieve it with existing QVD which has MTD values .I want to populate the values from backend only.Any ideas/suggestions ?
Existing QVD
Country Date Sales
A,2021-01-01,100
A,2021-01-02,200 (MTD values - Accumulation of 1st & 2nd of Jan)
..
..
A,2021-01-31,150000 (MTD values)
Expected QVD:
Country Date Sales
A,2021-03-31,10000000 (Sum of Jan 31+Feb 28+Mar 31 value)
