Group table rows in Reporting Canvas

You can organize the information in a report by displaying it in groups defined by currency, date, percentage, text, and time fields.

Prerequisites

Before you begin, you must enroll in the Reporting Canvas beta. For more information, see Reporting Canvas beta: overview.

Group rows in a table

  1. Click the Main Menu icon in the upper-right corner of Adobe Workfront, then click Reporting.

  2. Click New report.

    Or

    Go to an existing report, click the More Menu icon in the report header, then select Edit.

  3. To group rows on a new table, drag or double-click a table block onto the canvas.

    Or

    To group rows on an existing table, click the Edit icon in the table header.

  4. In the right panel, locate a field that you want to group by and drag it to the Group section.

    You can use the Search box to find a specific group.

  5. In the drop-down menu to the right of the Group field, select how you would like the group to be sorted.

    The options vary based on the type of field you are using to group your rows.

    table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 layout-auto html-authored no-header
    Currency
    • Smallest to largest

      Largest to smallest

    Date
    • Oldest to newest

    • Newest to oldest

    Percent
    • Smallest to largest

    • Largest to smallest

    Text
    • A to Z

    • Z to A

    Time
    • Smallest to largest

    • Largest to smallest

  6. Do any of the following:

    • To add another group, drag another field from the side panel.

    • To display rows in a group collapsed by default, click the More menu icon next to the group, then click Collapse group.

      Each group can be individually configured to display with rows collapsed or expanded. By default, all grouped rows are collapsed.

    • To display a count in the group row, click the More menu icon next to the group, then click Display count.

    • To remove a group, click the More menu icon next to the group, then click Remove group.

    • To rearrange multiple groups you have created, drag them into a new order.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43