Fri 19 Oct 2007, 12:53Delegate Darren said...
Darren has attended:
Excel Advanced course
Pivot Tables
After you have created a pivot table, how is it possible to suppress the total rows and columns and the grand total rows and columns.
Sat 20 Oct 2007, 16:57Trainer Roger said...
RE: Pivot Tables
Darren,
To suppress the grand totals, on the Pivot Table toolbar select Pivot Table, Pivot Table Options. In the dialog uncheck the 2 Grand Totals checkboxes.
To suppress the totals for intermediate groupings, double click the group header and select None under Subtotals.
Roger
