RadPivotGrid is a data summarization control where users can break down raw data in any manner they want. A pivot table can help quickly summarize the reports and highlight the desired information. It displays data in format such as spreadsheets or business intelligence applications. That is why it is good for showing reports in interactive web pages where the users can easily see the data they need.
Locate the database file which will be used for binding the PivotGrid in the AppData folder of your application.
Use the PivotGrid SmartTag to select the needed DataSource:
Set up your DataSource with the required fields:
and test the generated query:
After having the data set you could use the PivotGrid Collection Editor to set the Pivot Fields. Note that you should add a DataField property for them:
The PivotGrid will summarize the data like this: