public Form1()
        {
            InitializeComponent();

            PivotGridControlEx pivot = new PivotGridControlEx();

            pivot.Parent            = this;
            pivot.Dock              = DockStyle.Fill;
            pivot.FieldExpandedAll += new EventHandler <FieldExpandedEventArgs>(pivot_FieldExpandedAll);

            pivot.Fields.Add("group", PivotArea.RowArea);
            pivot.Fields.Add("product", PivotArea.RowArea);
            pivot.Fields.Add("sales", PivotArea.DataArea);

            DataTable table = new DataTable();

            table.Columns.Add("group", typeof(string));
            table.Columns.Add("product", typeof(string));
            table.Columns.Add("sales", typeof(int));
            table.Rows.Add("group 1", "product 1", 1);
            table.Rows.Add("group 1", "product 2", 2);
            table.Rows.Add("group 1", "product 3", 3);
            table.Rows.Add("group 2", "product 4", 4);
            table.Rows.Add("group 2", "product 5", 5);
            table.Rows.Add("group 2", "product 6", 6);
            pivot.DataSource = table.DefaultView;
        }
 public PivotGridViewInfoDataEx(PivotGridControlEx owner) : base(owner)
 {
 }