[]

Pivot tables let you summarize large quantities of data according to factors that you specify in order to get high-level insights on what your data means. For example, retail chains may have thousands of data points that represent purchases. Pivot tables are an ideal way for managers to view the total annual revenue for each region without having to enter multiple formulas.

To create a pivot table, open a Google Spreadsheet that contains your data. Select all the data, then choose Data from the toolbar. Scroll to "Pivot table report" and select the rows and columns to analyze, as well as the values. Your pivot table will appear, and can be reorganized by moving sections within the Report Editor up or down.