private void PivotGrid_CustomSummary(object sender, PivotCustomSummaryEventArgs e)
{
if (e.DataField.Name == Name)
{
if ((e.ColumnField == null) || (e.RowField == null))
{
//this is Grand Total cell
e.CustomValue = "Grand Total";
return;
}
int lastRowFieldIndex = PivotGrid.GetFieldsByArea(FieldArea.RowArea).Count() - 1;
int lastColumnFieldIndex = PivotGrid.GetFieldsByArea(FieldArea.ColumnArea).Count() - 1;
if (e.RowField.AreaIndex == lastRowFieldIndex && e.ColumnField.AreaIndex == lastColumnFieldIndex)
{
//this is Ordinary cell
e.CustomValue = e.SummaryValue.Summary;
}
else
{
//this is Total cell
e.CustomValue = "Total";
}
}
}