Hello community,
In my data set I get new YTD values every month but no monthly values for the individual month. My wish is to subtract the YTD value of the current month from the YTD value of the previous month. But only for KPIs which include “YTD” in their Name under the column KPI.
Example:
- P09 YTD - P08 YTD = MTD in P09
- P08 YTD - P07 YTD = MTD in P08
- P07 YTD - P06 YTD = MTD in P07
etc.
The search criteria shoud be: Fiscal Year / Period Month / RowIDs / BU / Consolidation / Reporting Unit Name / Commodity / BU specific / KPI
I made an example in the attached file.
This should be provided with the KPI 3 = MTD.
How can I do something like this?
Thanks for your help
Daten Substraction.xlsx (2.4 MB)