Excel: Remove subtotals on pivot table columns


Question:  How do I remove subtotals on a pivot table column?


Answer:  Select the column heading that you wish to remove subtotals on. In this example, we've chosen the column heading called Discount.




Right-click and then select "Field Settings" from the popup menu.




Under subtotals, select the "None" option. Click on the OK button.




Now when you return to the spreadsheet, the subtotals for each Discount are no longer visible.


Spreadsheet News


Book Shop


Visit our busy book shop, were you can find latest books for beginners as well as advanced excel users.



Excel Spreadsheet Software Library




Spreadsheet123

Spreadsheet 123 Spreadsheet Software Development

Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us
Home
About Us
About Spreadsheet
Book Shop
Excel Tutorials
1
Spreadsheets Library
3
4
5
6
Our Services
8
Site Map
Software
11
12
13
14
15
16
17