Pivot Table - Page View - Filtering problem, PLEASE HELP!!!!!

  • Thread starter Thread starter Felix Banuchi
  • Start date Start date
F

Felix Banuchi

I have created a pivot table and my page view sorting
option is not working properly. When I chose an item in
the page view, the resulting table is the same size as
before, but all the items that aren't included in that
view are set to "0" values. The items that are in the
page view setting have there correct values, but they are
intermixed in the long list. I have made pivot tables
before and never experienced this problem. I did not
realize that this was an option and don't know how to
change it. Any suggestions would be greatly appreciated.

Thanks,

Felix
 
If your pivot table includes a calculated item, you'll see all the
items, even when you apply a page filter.
 

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

Pivot Table Page Break Refresh Problem 0
Problem with Calculated item in Pivot Table 1
Pivot table filter list - listing irrelevant subcategorys 1
XL2007 - Pivot Table Limitations 2
Pivot table bottom ten filter with conditions 2
Single Filter to change all Pivot Tables in a Workbook 8
date filter in a pivot table 1
pivot table filter 6

Back
Top