Pivot tables- 0 counts don't display

  • Thread starter Thread starter Jim
  • Start date Start date
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!
 
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.
 
Back
Top