Change "Sum of {0}" text

[Barbaros Saglamtimur]

Hi,
If there is more than one  PivotGridAggregateField (lets say Aggregate="Sum") it adds "Sum of <filedname>" header.
So how can I change "Sum of <filedname>" and more over; "{0} Total" , "Grand Total" texts? I need to localize those strings.

TIA

[Joao]

I´m having the same problem... neither in portuguese nor in spanish the used legend goes well... any workaround? Thanks!

[Eyup]

Hi,

Please note that at the present time the RadPivotGrid control is in CTP version and does not have many of the functionalities which will be available via properties at its official release.

Nevertheless, you could try to apply the requested localization using the following approach:
  mark-up:

<telerik:PivotGridAggregateField DataField="TotalPrice" Aggregate="Sum" DataFormatString="{0:C}"
     GrandTotalAggregateFormatString="Gemeinsam: {0}" TotalFormatString="Gesamt: {0}">
 </telerik:PivotGridAggregateField>

  C#:

protected void RadPivotGrid1_CellDataBound(object sender, PivotGridCellDataBoundEventArgs e)
{
    if (e.Cell is PivotGridRowHeaderCell)
    {
        if (e.Cell.Text.IndexOf("Grand Total") >= 0)
        {
            e.Cell.Text = "Gesamtsumme:";
        }
    }

    else if (e.Cell is PivotGridColumnHeaderCell)
    {
        int index = e.Cell.Text.IndexOf("Total Sum of");
        if (index >= 0)
        {
            e.Cell.Text = e.Cell.Text.Replace("Total Sum of", "Gesamt Summe der");
        }
        else
        {
            index = e.Cell.Text.IndexOf("Sum of");
            if (index >= 0)
            {
                e.Cell.Text = e.Cell.Text.Replace("Sum of", "Summe der");
            }
        }

    }
}

That should do the trick. Please give it a try and let me know about the result.

Greetings,
Eyup
the Telerik team

[Joao]

Thaks so much Eyup!
Your solution solved quickly and in an elegant way this barrier of the version. I kown it is CTP but coudn't avoid using it because it's simple, pleasant and, above all, very powerfull.
Best regards!
Joao

[Nils C.]

Hi,

the "Grand Total" string is still missing in the localisation file or do i miss something?

Best 

Nils

[Eyup]

Hi Nils,

Currently, you will need to modify this text programmatically. You can log this requirement as a feature request so our developers will consider including it for the future releases:
http://feedback.telerik.com/Project/108/Feedback/List/Feature%20Request

Thank you for the feedback.

Regards,
Eyup
Telerik