PivotDashboardItem Class
A Pivot dashboard item that displays cross-tabular reports.
Namespace: DevExpress.DashboardCommon
Assembly: DevExpress.Dashboard.v21.2.Core.dll
Declaration
Remarks
The Pivot dashboard item presents data using cross-tabular reports.
The following documentation is available.
Example
The following example demonstrates how to bind a Pivot dashboard item to data in code.
using System;
using System.Windows.Forms;
using DevExpress.DashboardCommon;
namespace Dashboard_CreatePivot {
public partial class Form1 : Form {
public Form1() {
InitializeComponent();
}
private PivotDashboardItem CreatePivot(IDashboardDataSource dataSource) {
PivotDashboardItem pivot = new PivotDashboardItem();
pivot.DataSource = dataSource;
pivot.Columns.AddRange(new Dimension("Country"), new Dimension("Sales Person"));
pivot.Rows.AddRange(new Dimension("CategoryName"), new Dimension("ProductName"));
pivot.Values.AddRange(new Measure("Extended Price"), new Measure("Quantity"));
pivot.AutoExpandColumnGroups = false;
pivot.AutoExpandRowGroups = true;
return pivot;
}
private void Form1_Load(object sender, EventArgs e) {
Dashboard dashboard = new Dashboard();
DashboardExcelDataSource dataSource = new DashboardExcelDataSource()
{
FileName = "SalesPerson.xlsx",
SourceOptions = new DevExpress.DataAccess.Excel.ExcelSourceOptions(
new DevExpress.DataAccess.Excel.ExcelWorksheetSettings()
{
WorksheetName = "Data",
CellRange = "A1:L100"
}
)
};
dataSource.Fill();
dashboard.DataSources.Add(dataSource);
PivotDashboardItem pivot = CreatePivot(dataSource);
dashboard.Items.Add(pivot);
dashboardViewer1.Dashboard = dashboard;
dashboardViewer1.ReloadData();
}
}
}
Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the PivotDashboardItem class.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
Implements
Inheritance
Object
DashboardItem
DataDashboardItem
PivotDashboardItem
See Also
Feedback