CSharp_PivotGridControl和ChartControl简单实现<增强版>；

->效果

->完整源码

using System;
using System.Collections.Generic;
using System.Data;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using System.Data.OleDb;
using DevExpress.XtraPivotGrid;
using DevExpress.LookAndFeel;
using DevExpress.XtraCharts;

namespace HelloWorld
{
    public partial class XtraForm_Main : XtraForm
    {
        // 图表
        ChartControl chart;
        ChartControl bindedChart;

        public XtraForm_Main()
        {
            InitializeComponent();
        }

        private void XtraForm_Main_Load(object sender, EventArgs e)
        {
            // 查看图表按钮
            barBtnOperate.Alignment = DevExpress.XtraBars.BarItemLinkAlignment.Right;

            // 销售员汇总表
            pivotGridCtrlConfig();
        }

        /// <summary>
        /// 汇总表配置
        /// </summary>
        private void pivotGridCtrlConfig() {            
            BindingSource pivotBsource = new BindingSource(getDataSet("tableSales"), "tableSales");
            pivotGridCtrlSales.DataSource = pivotBsource;
            // 行区域
            PivotGridField fieldRegion = new PivotGridField("salesRegion", PivotArea.RowArea) { Caption = "地区" };
            PivotGridField fieldSalesName = new PivotGridField("salesName", PivotArea.RowArea) { Caption = "销售员" };
            // 列区域
            PivotGridField fieldTime = new PivotGridField("salesTime", PivotArea.ColumnArea)
            {
                GroupInterval = PivotGroupInterval.DateYear /* 按年度分隔；*/,
                /*fieldTime.GroupInterval = PivotGroupInterval.DateMonth;     // 按月份分隔；*/
                /*fieldTime.GroupInterval = PivotGroupInterval.DateQuarter;       //按季度分隔；*/
                Caption = "销售时间"
            };
            PivotGridField fieldProduct = new PivotGridField("product", PivotArea.ColumnArea) { Caption = "产品分类" };
            // 过滤器
            PivotGridField fil