Pivot table missing customers



I have a pivot table the summarizes data along the left, first by product,
then by customers that bought that product. NO filters are set to mask any
of the data, yet I have products that list a sub-total, but no customers.

I've confirmed that my entire range is selected, so the range should see the
customer names.

I've tried recreating the pivot table from the ground up and the new pivot
table works fine.

What might cause the original pivot table to "lose" some customers?



Debra Dalgleish

Have you refreshed the pivot table?
Could some of the rows be manually hidden?

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