2 posts, 0 answers
  1. Syed
    Syed avatar
    36 posts
    Member since:
    Sep 2013

    Posted 23 Oct 2013 Link to this post

    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

  2. Maria Ilieva
    Maria Ilieva avatar
    4017 posts

    Posted 28 Oct 2013 Link to this post

    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.

    Maria Ilieva
    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.
Back to Top