A spreadsheet tool that groups and summarises data so it can be compared by category.
A pivot table creates a summary from a larger set of records by arranging selected fields into categories and calculating values for each group. Changing the fields or filters lets the user compare the same underlying information in different ways without rewriting the source records. For example, sales records can be grouped by product category and period to compare totals. The summary depends on the data included in its source and may need refreshing when that data changes. A pivot chart adds a visual representation of the summarised results.
In job listings
Tapestry required its Account Executive, Marketplace in London to have Excel expertise supporting data collation, trade analysis, pricing and product performance, including pivot tables. Grouping records in a pivot table lets an analyst compare performance across categories. Search local jobs for “pivot table”.
