Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Sorting and grouping columns in list reports

Updated on October 29, 2021

Make your report more readable and organized by grouping columns and sorting the column values. For example, you can sort and group the report results to present the cases that the user accessed most recently.

  1. If App Studio is not in Preview mode, in the header, click Preview application.
  2. In the header of App Studio, select the portal in which you manage reports.
  3. In the navigation pane, open the Report Browser by clicking Reports.
  4. Select the reports that you want to view:
    • To view your custom reports, click the My Reports tab.
    • To view all available reports, click the All reports tab.
  5. In the upper-right corner of the screen, click Edit report.
  6. Click ActionsSort.
  7. In the Sort and Group section, manage the report columns:
    ChoicesActions
    Sort the column valuesNext to the column name, in the Sort list, select a sorting method for the column.
    Note: You can apply different a sorting method for each column.
    Group the results
    1. Select the Group results check box.
    2. In the numeric list, select the number of columns to display as the group heading.
    3. Optional: To remove the rows that share the same values in all columns, select the Remove duplicate rows check box.
    Limit the number of displayed rows in the report
    1. In the Top/Bottom Rank section, in the Display list, select how you want to display the rows.
      For example, if you want to display the rows with the highest values, select Top Ranked.
    2. In the box next to the Display list, enter the maximum number of rows to include in the report.
    3. In the Rows list, select where you want to limit the rows.
      For example, if you want to limit the overall number of rows in the entire report, select Overall.
    4. In the based on field, press the Down arrow key, and then select a property to use.
  8. Click Apply changes.
For example: The following visualization presents how to limit the number of rows in the table by specifying certain conditions. The system retrieves five rows with the highest values in the Urgency of assignment property.
Sorting columns in list reports
Visualization that presents how to use sorting options in custom reports.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us