Using Summaries in Excel Report Output

Summaries may be exported as static text, or as live Excel formulas. To render summaries as formulas, select the option to include summary expressions on export . Otherwise, they are treated as static text.

To render summaries as live formulas, include the formula and the data relevant to the summary in the list frame or crosstab report. Only simple, non-nested summaries are exported as summary formulas. Formulas with nested or multiple functions, such as Total (Qty *3), Total (Min(Qty)), and Total (Qty) for Country are exported as static text. The following summary calculations are supported as Excel formulas: total, minimum, maximum, average, standard deviation, variance, and count.

Summary formulas are supported in Excel using hidden worksheets that store the contiguous data ranges and arguments used by the formulas. The summary formulas on the visible worksheets are updated from the hidden worksheets.

Tip: You unhide hidden worksheets in Excel using the Unhide command.

Summary expressions are rendered as static text when the summary is included in the report as follows:

• in a page header or footer

• in a stand alone text frame

• in nested, multi-dimensional crosstabs where data is interleaved

• in a column that has conditional formatting using the hidden style

• with an associated column that does not appear as a column in the report

• in a report that splits across multiple worksheets .