Pivot Table is one of the macros bundled in the Table Filter, Charts & Spreadsheets app. The macro allows you to summarize your table data and produce its aggregated view in the form of a pivot table. You can select the appropriate operation types as follows:

Add Pivot Table on the page

Step 1. Add the macro to your table. Choose the handy way to do this:

Read more:
Step 2. Select columns for calculation and aggregation:

Read more:
Step 3. Select the appropriate operation type:

Read more:

Find the answer to your question among the related FAQ

Filter tables with the help of the various filter types

Build various charts based on your table


Merge multiple tables, perform complex calculations and custom transformations

Use only one source table to build multiple charts and pivot tables

Output tables from CSV or JSON

Combine all the macros with each other and with built-in and third-party macros