Skip Navigation
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?


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:

  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 the Online Help User Guide documentation for the version your site is currently running. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.