pivot table data filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Thanks Debra for the clarification. I wasn't sure if I was doing something to cause this behavior.

Pivot Newbie
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2003 Pivot Table Filter (items dropped in the Page Fields) 1
date filter in a pivot table 1
Single Filter to change all Pivot Tables in a Workbook 8
PIVOT - Reference a cell outside the table for report filtering 2
Multiple listboxes to update pivot table? 2
pivot table filter 6
pivot table data 2
Pivot Tables 4

Back
Top