Pivot tables- 0 counts don't display

J

Jim

How can I get a 0 counts to display in the pivot chart
and subsequent graphs.
Thanks to Debra for answering my last question, it was a
big help!
 
D

Debra Dalgleish

You could enter a dummy record for each combination in the table, and
leave the door field blank. For example:

door floor core doortype
1 1 1
2 1 1
3 1 1

These records will be displayed in the column and row area, but won't be
counted in the data area, where 'Count of Door' is used.
 

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

Top