Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1) I have 2 fields in the Row section of the Pivot Table. Is there a way to
set it up so you don't have a total at the end of each value change in the
first field of the row section? I dont want any subtotals totals; just the
grand total.

2) Is there a way to tell the pivot table that on the columns not show the
blank or empty columns?

Thank you for your help,

Steven
 
To turn off the subtotals, right-click on the first Row field button.
Choose Field Settings.
Under Subtotals, choose None, and click OK

To hide columns, you can click the dropdown arrow on the column field button
Remove the check mark from items that you want to hide.
 
Back
Top