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

Advertisements

B

BrianB

Check the field settings (double click the grey field names) to mak
sure "show items with no data" is checked
 
You must log in or register to reply here.

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

Suppress Zeros in a Pivot Table 3
Hide zero values in a pivot table 3
Pivot Table - Hiding Zero Values 2
hiding zero values in a pivot 1
Pivot table hide zeros? 0
Suppressing Zero Rows in Pivot Tables 2
Pivot table zero values 0
Pivot Table Zero Value 12

Top