Microsoft Office Tutorials and References
In Depth Information
Changing Field Settings
Figure 8–26. The Field Settings dialog box
Click None OK, yielding this view (Figure 8–27):
Figure 8–27. Note the missing Salespeson subtotals
(You can also click PivotTable Tools Design tab Subtotals Do Not Show Subtotals .) T he r e -
that’s a lot tidier. But remember that there may be many other times when you may want to leave the
subtotals in view, particularly if the subcategory displays multiple values. It all depends on what the
data tell you, and what you want and need to see.
Search JabSto ::

Custom Search