Row fields and user created GrandTotals ?

[Julian]

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?

 

Thanks,

 

 

 

 

 

[Konstantin Dikov]

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.


Regards,
Konstantin Dikov
Telerik