Change no. of digits after decimal in PivotGrid dynamically

[Rohit]

Hi

How can I increase/decrease the number of digits after decimal in the pivotgrid for all cells on button click.

[Hristo]

Hello Rohit,

All you need to do is access the aggregate you want to customize and change its StringFormat property:

private void button1_Click(object sender, EventArgs e)
{
    PropertyAggregateDescription aggregate = this.provider.AggregateDescriptions[0] as PropertyAggregateDescription;
    aggregate.StringFormat = "0.0";
}

I hope this helps.

Regards,
Hristo
Progress Telerik