#1   Report Post  
Peter Aitken
 
Posts: n/a
Default 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.


  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting in PivotTable Aaron Howe Excel Discussion (Misc queries) 5 July 12th 05 09:49 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
An easy macro question and one I believe to be a little more diffi TroutKing Excel Worksheet Functions 3 January 18th 05 09:17 PM
Pivottable Dates JayBee Excel Discussion (Misc queries) 5 January 15th 05 08:43 PM
How do I set permanent secondary axis in PivotTable chart? Microlong Charts and Charting in Excel 3 January 8th 05 03:54 AM


All times are GMT +1. The time now is 05:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"