Set the Auto Group & Summarize Property
If you are using an OLAP data source, data is always summarized regardless of how this property is set. Unless to change the global setting. See more on that here. Or contact BlueNet to help you change this settings.
Auto Group & Summarize looks at the level of detail in your query (ie: the nominated data items) and then groups the records by the qualitative values and summarized the quantitative values to the level of detail defined by your qualitative values.
- Pause the pointer over the query explorer button and click a query.
- 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.
If Auto group and Summarize= NO, the report or query output would be something like this:
Auto group and Summarize= YES, the report or query output would be something like this: