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,