Report Studio

Set the query property Auto Group & Summarize to specify whether Report Studio should group non-fact data items (identifiers and attributes) and apply aggregate functions to aggregate fact data items in lists.

To set the auto group & summarize property:

1. Pause the pointer over the query explorer button and click the query that you want.
2. In the Properties pane, set the Auto Group & Summarize property to the value that you want:
3. To group non-aggregate fact data items and apply aggregate functions to aggregate fact data items in lists, set this property to Yes.
4. To render detail rows, set this property to No.

Related Topics:

• Summarizing Data—How to summarize data in your report.
• Use the Aggregate Button to Add Simple Summaries—How to add summaries using the aggregate button.
• Specifying Aggregation Properties for a Data Item—How to specify the aggregation properties for a data item..
• Aggregating Values in Crosstabs and Charts—How to aggregate values in crosstabs and charts.
• Specifying the Aggregation Mode—How to specify the aggregation mode for your report.

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved