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.
|
Visit our busy book shop, were you can find latest books for beginners as well as advanced excel users.
Spreadsheet 123 Spreadsheet Software Development
See Spreadsheets for:
a.Hotel Management b.Personal Budget
c.Corporate Finance d.Rating Calculation e.Real Estate and Mortgage
f.Web Calc