Scenario: The source data is coming in the form of ytd numbers. Below is an example of year to date (YTD) numbers:
The user wants to see the monthly values instead of the YTD values, below is the data which the user wants to see in the report:
Thus the monthly 2017.02 values are 2017.02 value – 2017.01 value.
Thus, the first month value will be as it is, the second month value will be second month – first month, the third month value will be third month value – second month value.