Groupings allow you to merge rows that share characteristics into a single row and automatically calculate the total for all numerical values.

For example, if you added a grouping for the Payment Method column in a Tickets report, you would see the total cost and total live tickets for each payment method.

Another example: Let’s say you wanted to know how many tickets sold on a given day. Add the Event Date column and then add a grouping for that same column. With this view, you would be able to see totals for each individual day when there were sales for your selected events.

Add a Grouping

1. Locate the Groupings section in the left toolbar and click Add
2. Click the Group rows by dropdown and select your preferred column
   1. The list of available groupings is predetermined based on your report type
   2. Selecting a grouping column that is not already featured in your report will automatically add it to the report
3. Click Save Changes

Like filters, your groupings appear in a color block at the top of the report. Remove a grouping by clicking the X adjacent to its title.

You can also click the Groupings block to view or edit existing groupings. Click Clear Groupings in this menu to remove all groupings at once.

You can further customize your report with:

• Columns
• Filters