Reports & charts — Group and sort

Group by collapses rows that share a value in one column into a single line per value. Numeric columns re-aggregate within each group (sums, or the aggregation's own operation for avg/min/max columns); text columns show the shared value, or a count like 3 values when members differ. The first column shows how many records each group contains, and formula columns don't appear in the Group by picker. When the grouped column holds dates, pick a period — By day, By week, By month, By quarter, or By year — to see totals over time, such as revenue by month. Exact value groups by the precise date instead. Bucketed groups come out in chronological order unless you set an explicit sort. Sort orders rows by any column, ascending or descending — numerically when both values are numbers, alphabetically otherwise.