Paste CSV data, pick a row field, an optional column field, and a value field to aggregate — sum, mean, count, min, max, or median. Useful for ad-hoc analysis without opening a spreadsheet.
A pivot table groups records by one or two categorical fields and reduces a third numeric field to a single number per cell. Use Count when no value field makes sense (e.g. how many records per region per quarter), Sum for totals, Mean for averages, and Median when the data is skewed by outliers. Set the column field to (none) to get a flat group-by instead of a cross-tab.