add option in pivot tables to remove subtotals for fields

[epsoanalyst]

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/comm...heet.functions

[Debra Dalgleish]

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

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


"epsoanalyst" wrote:

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