Set the Auto Group & Summarize Property

Set the Auto group & summarize query property to specify whether IBM® Cognos® Analytics - Reporting should group non-fact data items (identifiers and attributes) and apply aggregate functions to aggregate fact data items in lists.

If you are using an OLAP data source, data is always summarized regardless of how this property is set.

Procedure

  1. Click the Queries icon Queries icon, and click a query.
  2. Click the Show properties icon Show properties icon, and in the Properties pane, set the Auto group & summarize property:
    • To group non-aggregate fact data items and apply aggregate functions to aggregate fact data items in lists, set this property to Yes.
    • To render detail rows, set this property to No.