Entering Values with Dynamic Time Filters
In a table based on a planning model, you can enter data into cells calculated by dynamic time filters, including member functions such as YTD.
When you enter data on a YTD, QTD, or MTD value, the change in value is assigned to the last booked member of the date dimension.
For example, consider a table that shows YTD values for 2018, with $1 million booked to both January and February 2018 and the rest of the months unbooked:
If you change the YTD value for April 2018 from $2 million to $3 million, the extra $1 million will be booked to February 2018:
Inverse functions can be defined for calculated members based on restrictions that use dynamic time filters. This allows you to simulate planning scenarios by changing KPIs such as YOY growth, for example. For more information, see the Inverse formulas with dynamic time filters section of Inverse Formulas.