PivotTable question
 

When you are changing the field settings for a page field, you have the
option of changing how subtotals are done - count instead of sum for
example. But I do not see this making any difference in how the tabl;e is
displayed.

--
Peter Aitken

Remove the crap from my email address before using.

You won't see the selected subtotals unless you move the page field to
the row or column area.

Peter Aitken wrote:
When you are changing the field settings for a page field, you have the
option of changing how subtotals are done - count instead of sum for
example. But I do not see this making any difference in how the tabl;e is
displayed.



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