Pivot Table suppresses/hides zero values

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Check the field settings (double click the grey field names) to mak
sure "show items with no data" is checked
 
Back
Top