E
ExcelPeter218
I have a Pivot Table based on a Table that consists of the following fields:
Provider, Date, Pmt1, Pmt2, Pmt3, Pmt4
When I create the Pivot Table using the Insert->Pivot Table feature I
specify Provider and Date as Row Labels and Sum of each of the Pmt fields as
values.
The resulting table has a Grand Total at the bottom for the columns but I
cannot get a Grand Total for the rows at the right. When I check the Totals &
Filters tab under Pivot Table options both Grand Total boxes are checked.
Is there a way the get both Grand Totals at the same time.
Any advice would be greatly appreciated.
Provider, Date, Pmt1, Pmt2, Pmt3, Pmt4
When I create the Pivot Table using the Insert->Pivot Table feature I
specify Provider and Date as Row Labels and Sum of each of the Pmt fields as
values.
The resulting table has a Grand Total at the bottom for the columns but I
cannot get a Grand Total for the rows at the right. When I check the Totals &
Filters tab under Pivot Table options both Grand Total boxes are checked.
Is there a way the get both Grand Totals at the same time.
Any advice would be greatly appreciated.