using System;
using System.Windows.Forms;
using Syncfusion.Windows.Forms.PivotChart;
using Syncfusion.PivotAnalysis.Base;

namespace PivotChartDemo
{
    public partial class Form1 : Form
    {
        private PivotChart pivotChart1;
        
        public Form1()
        {
            InitializeComponent();
            
            // Register Syncfusion license (required for v16.2.0.x+)
            Syncfusion.Licensing.SyncfusionLicenseProvider.RegisterLicense("YOUR_LICENSE_KEY");
            
            // Initialize Pivot Chart
            pivotChart1 = new PivotChart();
            pivotChart1.Dock = DockStyle.Fill;
            
            // Bind data source
            pivotChart1.ItemSource = ProductSales.GetSalesData();
            
            // Configure Pivot Axis (hierarchical structure)
            pivotChart1.PivotAxis.Add(new PivotItem 
            { 
                FieldMappingName = "Product", 
                TotalHeader = "Total" 
            });
            pivotChart1.PivotAxis.Add(new PivotItem 
            { 
                FieldMappingName = "Country", 
                TotalHeader = "Total" 
            });
            pivotChart1.PivotAxis.Add(new PivotItem 
            { 
                FieldMappingName = "State", 
                TotalHeader = "Total" 
            });
            
            // Configure Pivot Legend (series categorization)
            pivotChart1.PivotLegend.Add(new PivotItem 
            { 
                FieldMappingName = "Date", 
                TotalHeader = "Total" 
            });
            
            // Configure Calculations (data aggregation)
            pivotChart1.PivotCalculations.Add(new PivotComputationInfo 
            { 
                FieldName = "Quantity", 
                Format = "#,##0" 
            });
            
            // Set chart type
            pivotChart1.ChartTypes = PivotChartTypes.Column;
            
            // Enable drill-down
            pivotChart1.AllowDrillDown = true;
            
            // Add to form
            this.Controls.Add(pivotChart1);
        }
    }
}

using System.Collections.Generic;

// Data model
public class SalesData
{
    public string Product { get; set; }
    public string Region { get; set; }
    public string Quarter { get; set; }
    public int Quantity { get; set; }
    public decimal Amount { get; set; }
}

// Create and bind data
private void BindPivotChart()
{
    List<SalesData> salesList = new List<SalesData>
    {
        new SalesData { Product = "Laptop", Region = "North", Quarter = "Q1", Quantity = 50, Amount = 50000 },
        new SalesData { Product = "Laptop", Region = "South", Quarter = "Q1", Quantity = 40, Amount = 40000 },
        new SalesData { Product = "Mouse", Region = "North", Quarter = "Q1", Quantity = 200, Amount = 6000 },
        // Add more data...
    };
    
    pivotChart1.ItemSource = salesList;
    
    // Configure fields
    pivotChart1.PivotAxis.Add(new PivotItem { FieldMappingName = "Product", TotalHeader = "Total" });
    pivotChart1.PivotLegend.Add(new PivotItem { FieldMappingName = "Quarter", TotalHeader = "Total" });
    pivotChart1.PivotCalculations.Add(new PivotComputationInfo 
    { 
        FieldName = "Amount", 
        Format = "C",
        SummaryType = SummaryType.DoubleTotalSum 
    });
}

// Add buttons or menu items to switch chart types
private void btnLineChart_Click(object sender, EventArgs e)
{
    pivotChart1.ChartTypes = PivotChartTypes.Line;
}

private void btnColumnChart_Click(object sender, EventArgs e)
{
    pivotChart1.ChartTypes = PivotChartTypes.Column;
}

private void btnAreaChart_Click(object sender, EventArgs e)
{
    pivotChart1.ChartTypes = PivotChartTypes.Area;
}

private void btnStackingColumn_Click(object sender, EventArgs e)
{
    pivotChart1.ChartTypes = PivotChartTypes.StackingColumn;
}

// Enable drill-down with multiple hierarchy levels
private void ConfigureDrillDown()
{
    pivotChart1.AllowDrillDown = true;
    
    // Define hierarchy: Category → Product → Region → State
    pivotChart1.PivotAxis.Clear();
    pivotChart1.PivotAxis.Add(new PivotItem 
    { 
        FieldMappingName = "Category", 
        TotalHeader = "All Categories" 
    });
    pivotChart1.PivotAxis.Add(new PivotItem 
    { 
        FieldMappingName = "Product", 
        TotalHeader = "All Products" 
    });
    pivotChart1.PivotAxis.Add(new PivotItem 
    { 
        FieldMappingName = "Region", 
        TotalHeader = "All Regions" 
    });
    pivotChart1.PivotAxis.Add(new PivotItem 
    { 
        FieldMappingName = "State", 
        TotalHeader = "All States" 
    });
}

// Enable automatic updates when data changes
private void ConfigureRealTimeUpdates()
{
    // Enable automatic chart updates
    pivotChart1.EnableUpdating = true;
    
    // Bind to observable collection or implement INotifyPropertyChanged
    var salesData = new BindingList<SalesData>(GetSalesData());
    pivotChart1.ItemSource = salesData;
    
    // Now any changes to salesData will automatically update the chart
}

// For bulk updates, use BeginUpdate/EndUpdate
private void BulkDataUpdate()
{
    pivotChart1.BeginUpdate();
    
    try
    {
        // Perform multiple data operations
        var data = (BindingList<SalesData>)pivotChart1.ItemSource;
        for (int i = 0; i < 100; i++)
        {
            data.Add(new SalesData { /* ... */ });
        }
    }
    finally
    {
        pivotChart1.EndUpdate(); // Chart updates once after all changes
    }
}

// Display multiple aggregated values with custom formatting
private void ConfigureMultipleCalculations()
{
    pivotChart1.PivotCalculations.Clear();
    
    // Total quantity
    pivotChart1.PivotCalculations.Add(new PivotComputationInfo
    {
        FieldName = "Quantity",
        Format = "#,##0",
        SummaryType = SummaryType.DoubleTotalSum,
        FieldHeader = "Total Qty"
    });
    
    // Total amount (currency)
    pivotChart1.PivotCalculations.Add(new PivotComputationInfo
    {
        FieldName = "Amount",
        Format = "C2",
        SummaryType = SummaryType.DoubleTotalSum,
        FieldHeader = "Total Amount"
    });
    
    // Average price
    pivotChart1.PivotCalculations.Add(new PivotComputationInfo
    {
        FieldName = "UnitPrice",
        Format = "C2",
        SummaryType = SummaryType.DoubleAverage,
        FieldHeader = "Avg Price"
    });
}