add option in pivot tables to remove subtotals for fields

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

Guest

suggestion to add option to remove subtotals for particular fields in pivot
tables. When you put more than one field in the in the "drop row fields
here" in order to further break down data, it is counterproductive to have
numerous subtotals within the primary perimeter selected.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
 
You can turn off the subtotals for a field --

In the pivot table, double-click on the field button for the row field that
doesn't need subtotals.
Under Subtotals, choose None, then click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Ability to sort data in Excel by fill color 2
Excel should let you sort by subtotals 2
DATEDIF FUNCTION NOT LISTED IN HELP 2
Loan amortization schedule should have subtotals for each year 2
Don't show all Pivot table subtotals 1
Multiple Subtotal levels in Excel 2003 2
Subtotal percents in pivot table 1

Back
Top