In this sample, all the data such as the field list in PviotPanel, the aggregated data shown in PivotGrid and the detail raw data for some cell are fetched from the DataEngine server api. We also have a client-side option if you perfer.
In this sample, the PivotPanel control is bound with the DataEngine api. And the PivotGrid control is used to show the aggregated data. When double clicking on some cell in the PivotGrid control, a new grid will pop up to show the detail raw data for the cell.
A list of available fields will show in the PivotPanel, and users will be able to drag fields between summary areas to generate data summaries (also known as "views"). Users can also configure the fields by setting their headers, summary functions, filters, and formats.
The PivotPanel control has properties that allow you to customize the view. Use the controls below to modify the values of these properties and see their effect:
- Dataset
- Row totals
- Column totals
- Show Zeros