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!
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!