Summarise data with a pivot table
Group and total large lists by any column with a pivot table.
- Select a cell in your data.
- On the Insert tab, choose PivotTable.
- Choose where the pivot table goes.
- In the side panel, drag fields to rows, columns, values and filters.
Values can be summed, counted, averaged and more, or shown as a percentage of a total. Dates can be grouped by year, quarter, month or day.
When the source data changes, refresh the pivot table, or use Refresh All on the Data tab.
Was this article helpful?
Related articles
Still need help?
Write to the Woosool team. Sign in with your Woosool Account and we reply by e-mail and in My requests.