I have a pivot table that split the sales information among the wholesalers.
When a selected a specific wholesaler in the item list, the pivot table
doesn't show any information, but when a I have all select(Show All) the
information are there, strange situation. Does someone have had this problem
in anytime?

I have a main table with around 9.000 lines x 20 columns

Regards from Brazil!

Maybe the wholesaler name is in your list twice, spelled differently, or
with extra spaces in one variation. When you select one, it has no
records, but the other spelling would show the connected data.

Pivot Table Question? Items wrote:
I have a pivot table that split the sales information among the wholesalers.
When a selected a specific wholesaler in the item list, the pivot table
doesn't show any information, but when a I have all select(Show All) the
information are there, strange situation. Does someone have had this problem
in anytime?

I have a main table with around 9.000 lines x 20 columns

Regards from Brazil!


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