A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

pivot table data filter



 
 
Thread Tools Display Modes
  #1  
Old June 23rd, 2004, 07:43 PM
pivot newbie
external usenet poster
 
Posts: n/a
Default pivot table data filter

Pivot experts,

I prepared a pivot table with several different summing data fields. If I view(filter) the pivot table with less than all the data fields, the unviewed fields drop off the table. I then need to rebuilt the table. Yet I can filter the column or row items, view the table, then select another filter for a different view. Am I missing something? Is there a setting that needs to be activated? I thought pivot tables were interactive--put all the data up, look at it one way, then look at it another.

Thanks for clarification.
Ads
  #2  
Old June 23rd, 2004, 09:40 PM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default pivot table data filter

There's no Unhide option for the data fields. Once you uncheck a field,
it's removed from the pivot table. You can drag the field back in from
the field list.


pivot newbie wrote:
Pivot experts,

I prepared a pivot table with several different summing data fields. If I view(filter) the pivot table with less than all the data fields, the unviewed fields drop off the table. I then need to rebuilt the table. Yet I can filter the column or row items, view the table, then select another filter for a different view. Am I missing something? Is there a setting that needs to be activated? I thought pivot tables were interactive--put all the data up, look at it one way, then look at it another.

Thanks for clarification.



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

  #3  
Old June 24th, 2004, 06:58 PM
pivot newbie
external usenet poster
 
Posts: n/a
Default pivot table data filter

Thanks Debra for the clarification. I wasn't sure if I was doing something to cause this behavior.

Pivot Newbie


"Debra Dalgleish" wrote:

There's no Unhide option for the data fields. Once you uncheck a field,
it's removed from the pivot table. You can drag the field back in from
the field list.


pivot newbie wrote:
Pivot experts,

I prepared a pivot table with several different summing data fields. If I view(filter) the pivot table with less than all the data fields, the unviewed fields drop off the table. I then need to rebuilt the table. Yet I can filter the column or row items, view the table, then select another filter for a different view. Am I missing something? Is there a setting that needs to be activated? I thought pivot tables were interactive--put all the data up, look at it one way, then look at it another.

Thanks for clarification.



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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
(blank) displayed in pivot table Keith Worksheet Functions 1 February 28th, 2004 02:53 AM
Charting 2 pivot data items as one result Scott Stewart Charts and Charting 4 January 9th, 2004 09:46 AM
lookup or match or max??? buffyslay Worksheet Functions 2 December 8th, 2003 11:47 AM


All times are GMT +1. The time now is 01:46 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.