Pivot Table suppresses/hides zero values

G

Guest

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?
 
B

BrianB

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

Similar Threads

Excel 2007 Pivot Tables - do not display zero values 2
Filter pivot table zero values 1
Display No Data in Pivot 1
Surpressing rows and columns with zero values in a pivot table 1
Pivot Table - Hiding Zero Values 2
Hiding Zero Values in a Pivot Table - MS Excel 2007 4
including zero values in a pivot table 2
Question on the occupied field of the pivot table in excel spreadsheet 0

Top