Aspose.Cells.GridWeb.Examples.CSharp.Miscellaneous.PivotTable.CreateCustomPivotTable.btnSubmit4_Click C# (CSharp) Method

        protected void btnSubmit4_Click(object sender, EventArgs e)
        {
            // Initialize Data
            InitData();

            GridWorksheet sheet = GridWeb1.WorkSheets["PivotTable Report"];

            GridPivotTable pivotTable = sheet.PivotTables[0];

            // Sets field Caption property to be show in the report
            pivotTable.Fields("Employee").DisplayName = txtEmployee.Text.Trim();
            pivotTable.Fields("Product").DisplayName = txtCountry.Text.Trim();

            // Paints PivotTable report
            pivotTable.CalculateData();
        }