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.
|
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