Pivot Table suppresses/hides zero values



I have a list of retail chains... products and amounts sold.

My pivot table does not show any of the retail chains that don't have sales. I've added zero data in the Access table I'm pulling from, but that doesn't seem to help. My Pivot table options and my general option are NOT set to hide zero values. It's something the table seems to be doing automatically.

Anyone have a suggestion?




Check the field settings (double click the grey field names) to mak
sure "show items with no data" is checked

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