Telerik hide PivotGridCalculatedItem programmatically

[Sagar]

Hi ,

I want to hide PivotGridCalculatedItem column programmatically on checkbox change event,is there any provision to do so.

 

Thanks,

Sagar Jaunjalkar

[Eyup]

Hello Sagar,

You can use the following approach to achieve this requirement:

protected void Button1_Click(object sender, EventArgs e)
{
    PivotGridColumnField field = RadPivotGrid1.Fields["Year"] as PivotGridColumnField;
    var calItems = field.CalculatedItems.OfType<PivotGridCalculatedItem>();
    PivotGridCalculatedItem item = calItems.Where(x => x.GroupName == "Forecast for 1999").FirstOrDefault();
    field.CalculatedItems.Remove(item);
    RadPivotGrid1.Rebind();
}

The example above is adjusted for this live sample:
http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/calculations/defaultcs.aspx

I hope this will prove helpful.

Regards,
Eyup
Telerik