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
1. Build (or register) a range, with Time dimensions used as row or column headers.
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.
Syntax
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
- __-TD
- __-YTD
- TD __
- YTD __
- TD__
- YTD__
- TD-__
- YTD-__
Comments
0 comments
Please sign in to leave a comment.