Skip Navigation
Expand
Duplicate data in reports
Answer ID 4631   |   Last Review Date 11/14/2018

How can I get my report to display only unique values instead of having multiple rows with the same value?

Environment:

Analytics, Group Results

Resolution:

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:

  1. Open the report in edit mode
  2. Select the output level you want to edit from the Level drop-down menu at the top of the design surface
  3. Click the Level tab on the ribbon
  4. Click on the 'Group Results' checkbox located in the Grouping Section
  5. 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.

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.