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 for more information).

Designate a Field as an GEXQ Summary Field

1. In the Field List panel, 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.