View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Todd1
 
Posts: n/a
Default Pivot tables with zero/null values

I have a pivot table that hits a database each day that shows daily
transaction activity. The activity could have values from zero to several
hundred. I want to graph the activity by day. How do I get a pivot table to
show ZERO if there was no activity? Right now, it is null and therefor skips
the day with no activity and the graph never shows the zero amount. See
example below:

Current (not what I'm trying to do)
3/1 17
3/2 4
3/4 72
3/5 21

Desired
3/1 17
3/2 4
3/3 0
3/4 72
3/5 21