Example of Field List in Blazor Pivot Table Component
This sample demonstrates the Excel-like field list feature of the pivot table. The pivot fields are automatically populated from the bound data source, and they can be dragged and dropped to create and alter the report at runtime.
Grand Total |
|---|
| Grand Total | No records to display |
Pivot Field List
Drag fields between axes below:
Filters
Rows
Columns
Values
The pivot table provides a built-in field list very similar to Microsoft Excel. The top section of the
field list allows the user to add and remove fields. The bottom section of the field list allows the user to rearrange the
fields between different axes, including column, row, value, and filter along with filter and sort options.
To show the field list independently, create as separate component namely
SfPivotFieldList and assign JSON data source to its
PivotFieldListDataSourceSettings->DataSource property. Simultaneously, pivot table will be populated by passing its instance in
the UpdateViewAsync method, inside the
EnginePopulated event of field list.
Additionally, user interface for calculated field, label filter, and value filter features have been enabled in this demo by setting the properties
PivotFieldList->AllowCalculatedField,
PivotFieldListDataSourceSettings->AllowLabelFilter and PivotFieldListDataSourceSettings->AllowValueFilter to true.
More information on the field list can be found in this documentation section.