This is a migrated thread and some comments may be shown as answers.

ColumnGrandTotalDataCell

1 Answer 27 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Syed
Top achievements
Rank 1
Syed asked on 23 Oct 2013, 08:15 AM
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
                    }
                }
            }

1 Answer, 1 is accepted

Sort by
0
Maria Ilieva
Telerik team
answered on 28 Oct 2013, 09:08 AM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Tags
PivotGrid
Asked by
Syed
Top achievements
Rank 1
Answers by
Maria Ilieva
Telerik team
Share this question
or