We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Remove "Drop pivot fields here to filter by"


I am Using Winforms PivotGrid Control in a C# .NET application. I want to remove text "Drop pivot fields here to filter by". By any means is there any possibility to remove or change this text?

2 Replies

TB Thirupathi Bala Krishnan Syncfusion Team July 12, 2019 08:46 AM

Hi Bilal Raja 
Thanks for contacting Syncfusion support.

Currently we are checking on the reported query-“How to change the filter area header text”, we will validate and update you the further details on July 15, 2019.
We appreciate your patience until then. 

Thirupathi B.

SP Subburaj Pandian Veluchamy Syncfusion Team July 15, 2019 05:47 AM

Hi Bilal Raja, 
Thank you for your patience.

We have analyzed the reported query “
How to change the filter area header text in pivot grid control”. You can achieve this requirement by assigning the own text value inside the QueryCellInfo even thandler of FilterArea. Here, the text values are rendered based on the given row and column index within the event handler. 

Please refer the following code example,
# Form1.cs
       public Form1() 
        private void InitializePivotGrid() 
            // Adding ItemSource to the Control 
            this.pivotGridControl1.ItemSource = ProductSalesData.GetSalesData(); 
            // Adding PivotRows to the Control 
            this.pivotGridControl1.PivotRows.Add(new PivotItem { FieldMappingName ="Product", TotalHeader = "Total" }); 
            this.pivotGridControl1.PivotRows.Add(new PivotItem { FieldMappingName ="Date", TotalHeader = "Total" }); 
            // Adding PivotColumns to the Control 
            this.pivotGridControl1.PivotColumns.Add(new PivotItem { FieldMappingName = "Country", TotalHeader = "Total" }); 
            this.pivotGridControl1.PivotColumns.Add(new PivotItem { FieldMappingName = "State", TotalHeader = "Total" }); 
            // Adding PivotCalculations to the Control 
            this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo { FieldName = "Amount", Format = "$ #,##0.00", SummaryType = SummaryType.DoubleTotalSum }); 
            this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo { FieldName = "Quantity", Format = "#,##0" }); 
            this.pivotGridControl1.ShowGroupBar = true; 
           this.pivotGridControl1.TableControl.FilterArea.QueryCellInfo += FilterArea_QueryCellInfo; 
        private void FilterArea_QueryCellInfo(object sender, GridQueryCellInfoEventArgs e) 
            if (e.RowIndex == 2 && e.ColIndex == 1) 
                e.Style.Text = "Drop fields here"; 
                e.Style.TextColor = System.Drawing.Color.White; 

Please refer the following screenshot,

We hope this helps. Please let us know, if you would require any further assistance. 
Subburaj Pandian V 

Live Chat Icon For mobile
Up arrow icon