How to Fetch Data To Date

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-__