software

suggestion to add option to remove subtotals for particular fields in pivot
tables. When you put more than one field in the in the quot;drop row fields
herequot; 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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

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 amp; Book List
www.contextures.com/tiptech.htmlquot;epsoanalystquot; wrote:

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