Pivot Table
The Avonni Data Driven Pivot Table displays aggregated records in a pivot table format, with groupable rows and columns, optional subtotals and grand totals, and a configurable header and filter section. Unlike the other data driven components, the pivot table cannot rely on the base component to run the query: the records must be aggregated server-side with a `GROUP BY CUBE` query before they can be displayed. This component therefore builds the aggregate query from the `mapping`, executes it, and feeds the pre-aggregated rows to the base component as static items.
Built with Avonni Dynamic Components from the Avonni Experience Components package (avxp): the dcPivotTable element inside a Dynamic Component. Deploy the custom metadata record from the Code tab first, then add the Dynamic Component to the page in Lightning App Builder.