Pivot table features, majority of them available for all dashboard gadgets:
- Multi level grouping
- Multi column sorting
- Filtering (when not grouped)
- Export in CSV (Excel readable)

The pivot table with 2 level break down of data.

The pivot table with 3 level break down of data.

Please check the recording below with few configuration use cases.
