How to group days in a pivot table, but to include field header daysfor which no entries are found (

  • Thread starter Thread starter Mike C
  • Start date Start date
M

Mike C

I have a pivot table that groups data by day (as a field header) like
this:

1/1/08 1/2/08 1/3/08 1/5/08 1/6/08
Category 1 10 20 22 23 etc
Category 2
Category 3

I need the missing dates to show up as and show zeros (or blanks). So
in the above example, I need 1/4/08 to not be skipped.

Any suggestions?

Thanks!
 
Hi Mike

Double click on your date field Header>Show missing items

--
Regards
Roger Govier










- Show quoted text -
Click to expand...

Thanks Mike. That is a great feature. However, when there are not
any entries for 1/4/08 (eg), it still does not bring up 1/4/08.
Perhaps I am simply out of luck. I may just have to go in manually to
insert the days for which no data exists, or build a macro of some
sort.....
 
Thanks Mike.  That is a great feature.  However, when there are not
any entries for 1/4/08 (eg), it still does not bring up 1/4/08.
Perhaps I am simply out of luck. I may just have to go in manually to
insert the days for which no data exists, or build a macro of some
sort.....- Hide quoted text -

- Show quoted text -
Click to expand...

You could put a dash or something to represent an empty field. So you
would need only one entry for 1/4/08 with a dash in the appropriate
cell.
 
Back
Top