Excel: Remove subtotals on pivot table rows


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


Answer:  Select the row heading that you wish to remove subtotals on. Right-click and then select "Field Settings" from the popup menu. In this example, we've chosen the row heading called Order ID.




When the PivotTable Field window appears, select the "None" subtotals option. Click on the OK button.




Now when you return to the spreadsheet, the subtotals for each OrderID 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