How to group days in a pivot table, but to include field header days for which no entries are found (see example)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike C - 15 Feb 2008 06:47 GMT

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!

Reply to this Message

Roger Govier - 15 Feb 2008 12:48 GMT

Hi Mike

Double click on your date field Header>Show missing items

Signature

Regards
Roger Govier

> I have a pivot table that groups data by day (as a field header) like
> this:
[quoted text clipped - 10 lines]
>
> Thanks!

Reply to this Message

Dave K - 15 Feb 2008 14:37 GMT

On Feb 15, 6:48 am, "Roger Govier"
<roger@technology4unospamdotcodotuk> wrote:

> Hi Mike
>
[quoted text clipped - 20 lines]
>
> - Show quoted text -

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

Reply to this Message

Aviashn - 15 Feb 2008 14:51 GMT

> On Feb 15, 6:48 am, "Roger Govier"
>
[quoted text clipped - 35 lines]
>
> - Show quoted text -

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.

Reply to this Message