Create the Summary Field

A summary field is used to summarize (total, count, average, etc.) a selected numeric field. In Excel, a GEXQ formula is then used to return a single value from the GEXQ (summary) portion of a query to a spreadsheet. Users may then drill down on the summary value to see detailed results (see "GEXQ Formula" in the Spreadsheet Server User Guide for more information).

Designate a Field as an GEXQ Summary Field

1. In the Field List grid, select the desired field, right-click, then, select Set as Summary Field (GEXQ). The Summary Field panel appears.

2. In the Summary Field panel, select the desired summary type.

Note: If a field is already defined as a summary field, Remove Summary Field (GEXQ) is enabled. For all other fields, this option is disabled.


3. Click the OK button.
4. Defining a field as the summary field creates SQL code, that is executed when the GEXQ is run in Excel. This code is displayed in the Summary tab, in the SQL panel.