PivotDashboardItem Class

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();
        }
    }
}

Imports System
Imports System.Windows.Forms
Imports DevExpress.DashboardCommon

Namespace Dashboard_CreatePivot
    Partial Public Class Form1
        Inherits Form

        Public Sub New()
            InitializeComponent()
        End Sub
        Private Function CreatePivot(ByVal dataSource As IDashboardDataSource) As PivotDashboardItem
            Dim pivot As 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
        End Function
        Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load

            Dim dashboard As New Dashboard()
            Dim dataSource As New DashboardExcelDataSource() With {.FileName = "SalesPerson.xlsx", .SourceOptions = New DevExpress.DataAccess.Excel.ExcelSourceOptions(New DevExpress.DataAccess.Excel.ExcelWorksheetSettings() With {.WorksheetName = "Data", .CellRange = "A1:L100"})}
            dataSource.Fill()
            dashboard.DataSources.Add(dataSource)

            Dim pivot As PivotDashboardItem = CreatePivot(dataSource)
            dashboard.Items.Add(pivot)

            dashboardViewer1.Dashboard = dashboard
            dashboardViewer1.ReloadData()
        End Sub
    End Class
End Namespace

how-to-bind-a-pivot-dashboard-item-to-data-in-code-e4772/CS/Dashboard_CreatePivot/Form1.cs#L10

}
private PivotDashboardItem CreatePivot(IDashboardDataSource dataSource) {
    PivotDashboardItem pivot = new PivotDashboardItem();

how-to-bind-a-range-filter-dashboard-item-to-data-in-code-e4773/CS/Dashboard_CreateRangeFilter/Form1.cs#L43

private PivotDashboardItem CreatePivot(IDashboardDataSource dataSource)
{

winforms-dashboard-window-calculation-example/CS/WindowCalculationExample/Form1.cs#L36

{
    PivotDashboardItem pivotItem = dashboardViewer1.Dashboard.Items[pivotItemName] as PivotDashboardItem;
    if (pivotItem != null)

win-designer-pivot-as-master-filter/CS/DesignerSample/Form1.cs#L88

void ClearPivotFilter() {
    PivotDashboardItem pivotItem = dashboardDesigner1.Dashboard.Items["pivotDashboardItem1"] as PivotDashboardItem;
    ClearParameters(pivotItem.Columns);

how-to-apply-filtering-to-a-dashboard-items-data-in-olap-mode-e5148/CS/Dashboard_OlapFiltering/Form1.cs#L12

dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml");
PivotDashboardItem pivot1 = (PivotDashboardItem)dashboard.Items[0];
DashboardOlapDataSource olapDataSource = (DashboardOlapDataSource)dashboard.DataSources[0];

how-to-bind-a-pivot-dashboard-item-to-data-in-code-e4772/VB/Dashboard_CreatePivot/Form1.vb#L12

End Sub
Private Function CreatePivot(ByVal dataSource As IDashboardDataSource) As PivotDashboardItem
    Dim pivot As New PivotDashboardItem()

how-to-bind-a-range-filter-dashboard-item-to-data-in-code-e4773/VB/Dashboard_CreateRangeFilter/Form1.vb#L39

Private Function CreatePivot(ByVal dataSource As IDashboardDataSource) As PivotDashboardItem

winforms-dashboard-window-calculation-example/VB/WindowCalculationExample/Form1.vb#L32

Private Sub ApplyPivotWindowCalculations(ByVal pivotItemName As String)
    Dim pivotItem As PivotDashboardItem = TryCast(dashboardViewer1.Dashboard.Items(pivotItemName), PivotDashboardItem)
    If pivotItem IsNot Nothing Then

win-designer-pivot-as-master-filter/VB/DesignerSample/Form1.vb#L92

Private Sub ClearPivotFilter()
    Dim pivotItem As PivotDashboardItem = TryCast(dashboardDesigner1.Dashboard.Items("pivotDashboardItem1"), PivotDashboardItem)
    ClearParameters(pivotItem.Columns)

how-to-apply-filtering-to-a-dashboard-items-data-in-olap-mode-e5148/VB/Dashboard_OlapFiltering/Form1.vb#L14

dashboard.LoadFromXml("..\..\Data\Dashboard.xml")
Dim pivot1 As PivotDashboardItem = CType(dashboard.Items(0), PivotDashboardItem)
Dim olapDataSource As DashboardOlapDataSource = DirectCast(dashboard.DataSources(0), DashboardOlapDataSource)