Pivot Table is one of the macros bundled in the Table Filter and Charts for Confluence 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: