protected void ASPxPivotGrid1_CustomFieldValueCells(object sender, DevExpress.Web.ASPxPivotGrid.PivotCustomFieldValueCellsEventArgs e)
{
bool isColumn = true;
for (int i = e.GetCellCount(isColumn) - 1; i >= 0; i--)
{
FieldValueCell cell = e.GetCell(isColumn, i);
if (cell != null)
{
e.Remove(cell);
}
}
}
protected void ASPxPivotGrid1_CustomFieldValueCells(object sender, DevExpress.Web.ASPxPivotGrid.PivotCustomFieldValueCellsEventArgs e)
{
PivotGridField fieldYear = ASPxPivotGrid1.Fields["fieldOrderYear"];
if (fieldYear.Area == PivotArea.ColumnArea || fieldYear.Area == PivotArea.RowArea)
{
bool isColumn = fieldYear.Area == PivotArea.ColumnArea;
for (int i = e.GetCellCount(isColumn) - 1; i >= 0; i--)
{
FieldValueCell cell = e.GetCell(isColumn, i);
if (unnecessaryYearTotals.Contains(cell.Value) && cell.ValueType == PivotGridValueType.Total)
{
e.Remove(cell);
}
}
}
}