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

Row fields and user created GrandTotals ?

1 Answer 13 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Julian
Top achievements
Rank 1
Julian asked on 27 Apr 2015, 03:30 PM

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,

 

 

 

 

 

1 Answer, 1 is accepted

Sort by
0
Konstantin Dikov
Telerik team
answered on 30 Apr 2015, 11:30 AM
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
 

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

 
Tags
PivotGrid
Asked by
Julian
Top achievements
Rank 1
Answers by
Konstantin Dikov
Telerik team
Share this question
or