Use Detail Data Instead of Grouped and Aggregated Data

By default, the records in a relational data source are grouped and aggregated. This means that there is a single record for each unique combination of values across all categories in the report section. The aggregation setting is for the entire section, not for a single object.

For multidimensional data, you cannot change the grouping or aggregation. For relational data, you cannot use detail data if the report section contains any of these items:

a crosstabulation table or a graph, with the exception of scatter plots that use relational data
one or more custom data items

In all other circumstances, to use detail data, complete these steps:

Select DataSummarization Options to open the Summarization Options dialog box.
Select one of these options:

Show every row (Detail data)

Select this option to show every record in the data source.

Show every row, excluding duplicates (Detail data)

Select this option to show every record in the data source and to exclude duplicate records (records where the value for the category data item or data items is identical).

Note: To base a scatter plot or bubble plot on data that is not aggregated, select one of the detail data options.
Click OK.