Pivot Table suppresses/hides zero values

M

Milez

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
 
Top