How can I get my report to display only unique values instead of having multiple rows with the same value?
Analytics, Group Results
Grouping data in an output level allows you to combine records with similar data into one row. Output levels with grouped data often have additional output levels added to them, so you can drill down into another output level to view details about the grouped records. When you group data, you can order the grouped columns to best suit your needs when you create drill-down output levels.
To enable grouping:
- Open the report in edit mode
- Select the output level you want to edit from the Level drop-down menu at the top of the design surface
- Click the Level tab on the ribbon
- Click on the 'Group Results' checkbox located in the Grouping Section
- Save the report
For additional information, refer to the 'Enable grouping in an output level' section in online documentation for the version your site is currently running. To access Oracle Service Cloud manuals and documentation online, refer to the Documentation for Oracle Service Cloud Products.