ColumnGrandTotalDataCell

[Syed]

hi
In my pivot grid i use ColumnGrandTotalDataCell where i get the Sum or rows.

i want for a partecular column to be set as max value and remaining rows aggregate as sum.

example in Celldatabound

if (cell.CellType == PivotGridDataCellType.ColumnGrandTotalDataCell || cell.CellType == PivotGridDataCellType.RowGrandTotalDataCell)
            {
                if ((cell.Field as PivotGridAggregateField).DataField == "Amount")
                {
                    string maxvaluerow = cell.ParentRowIndexes[1].ToString();

                    if (maxvaluerow  == "11")
                    {
                        cell.Text = "";
                        //  here i want to set the grandtotal result as Max value of row
                    }
                }
            }

[Maria Ilieva]

Hello Syed,

I am afraid the required functionality is not a supported scenario. You can have different aggregate functions for the different aggregate fields but not for each column.

Regards,
Maria Ilieva
Telerik