Row fields and user created GrandTotals ?

2 posts, 0 answers
  1. Julian
    Julian avatar
    61 posts
    Member since:
    Apr 2015

    Posted 27 Apr 2015 Link to this post

    I have the need to either, create my own GrandTotal column to the right of the grid or .. allow me to show a PivotGridRowField to the right of the report. 


    Here are my fields (that are displayed as columns): 

    PivotGridColumnFIeld: Period

    PivotGridAggregateFields: Plan, Actual


    I want to add a column that is a percentage of Actual / Plan but I only want this column to show at the end in the GrandTotals section? Is there any way to do this?


    Also, is there anyway to display PivotGridRowFields to the right of the GrandTotal columns?








  2. Konstantin Dikov
    Konstantin Dikov avatar
    2386 posts

    Posted 30 Apr 2015 Link to this post

    Hi Julian,

    Although that there is no way to hide only the sub totals for a particular field, you can use the following properties to customize the position and the visibility of the totals:
    • TotalsSettings-ColumnGrandTotalsPosition
    • TotalsSettings-ColumnsSubTotalsPosition
    • TotalsSettings-RowGrandTotalsPosition
    • TotalsSettings-RowsSubTotalsPosition
    • TotalsSettings-GrandTotalsVisibility

    Hope this helps.

    Konstantin Dikov

    See What's Next in App Development. Register for TelerikNEXT.

Back to Top