This demo includes a set of reports which allows you analyze the same business data in different forms. Use the Radio buttons to switch between the reports. Category Sales In this report the ASPxPivotGrid control displays the total amount of sales for each category of product. Product Sales In this report the ASPxPivotGrid control shows the total amount of sales for each product. Check the Show Categories check box to view products by categories. For each category a total will be automatically calculated. Interval Grouping In this report the ASPxPivotGrid control allows you to view the amount of sales for each category and product according to the shipping date. You can categorize the information by year, quarter and(or) month. Multiple Subtotals In this report the ASPxPivotGrid calculates multiple summaries (Sum, Average, Max and Min) for each product category. It breaks the information down into years and quarterly intervals so that you can analyze the information according to the shipping date. Average Sales In this report the ASPxPivotGrid control calculates the total, average and minimum sales amount for each category. Top 3 Products This report shows the three most popular products in each category. Clicking the 'Product Name' field header reverses the current sort order and the report will show you the three least popular products in each category. Local Copy of this Demo To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer. You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher). Open CS Solution Open VB Solution The source code files for this demo are installed (by default) in the following directories: \Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxPivotGridDemos \Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxPivotGridDemos