We've simplified the work it takes to calculate to-date values for your variance analysis. Just add "TD" or "YTD" to your Time headers to return the to-date value.
Set up your Headers and Fetch
2. Edit one of the Time dimensions to include a To-Date header (see supported syntax below).
3. Fetch data to your sheet.
Note: Be sure to include at least one normal time dimension in the selected range.
The following syntaxes can be used to fetch the to-date data of a given time dimension - just swap the "__" with a valid time period, e.g. Jun-20 TD or YTD Apr-18.
- __ TD
- __ YTD
- TD __
- YTD __