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:

Step 2. Select columns for calculation and aggregation:

Step 3. Select the appropriate operation type:

Output tables from CSV or JSON