private void Form1_Load(object sender, EventArgs e)
        {
            pivotGridControl1.DataSource = PivotHelper.GetFullDataTable();
            pivotGridControl1.BestFit();
            fieldProductName.Options.AllowSort = DefaultBoolean.False;

            pivotGridControl1.BeginUpdate();
            fieldProductName.FilterValues.ValuesIncluded = new object[] { "Alice Mutton", "Aniseed Syrup" };
            pivotGridControl1.EndUpdate();
        }
 private void btnRestoreDSRecords_Click(object sender, EventArgs e)
 {
     pivotGridControl1.DataSource = PivotHelper.GetFullDataTable();
 }