date series in PivotTables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KFuda - 06 Apr 2007 19:06 GMT

I often use PivotTables to count events that occur on specific dates. The
PivotTable only shows those dates that have at least one event associated
with them; however, I am also interested in seeing which dates had no events.
Is there a way to force the pivot table to show the dates as a series, so
that dates with 0 events are displayed? For example, if I want to show the
number of patients admitted from 12/1/06 to 12/7/06, but in fact there were
only admissions on 12/1, 12/3, and 12/5, the pivottable will show me only 3
dates, but I want to see all 7 dates in the range.

Reply to this Message

Barb Reinhardt - 06 Apr 2007 20:22 GMT

In order to see the dates with no patients admitted, you'd have to have those
dates in your source range.

> I often use PivotTables to count events that occur on specific dates. The
> PivotTable only shows those dates that have at least one event associated
[quoted text clipped - 4 lines]
> only admissions on 12/1, 12/3, and 12/5, the pivottable will show me only 3
> dates, but I want to see all 7 dates in the range.

Reply to this Message

Roger Govier - 06 Apr 2007 21:48 GMT

Hi

Double click on field, bottom left of dialogue, select "Show Items with
no data"

Signature

Regards

Roger Govier

>I often use PivotTables to count events that occur on specific dates.
>The
[quoted text clipped - 11 lines]
> only 3
> dates, but I want to see all 7 dates in the range.

Reply to this Message

KFuda - 07 Apr 2007 19:56 GMT

I tried this, but it did not force the pivottable to display the entire range
of dates. It displays only those dates for which there is actually data.

> Hi
>
[quoted text clipped - 15 lines]
> > only 3
> > dates, but I want to see all 7 dates in the range.

Reply to this Message

Debra Dalgleish - 08 Apr 2007 01:43 GMT

Turn on the 'Show items with no data' option that Roger described
Then, right-click a cell in the date field of the pivot table
ChooseGroup and Show Detail>Group
Select Years and Days, click OK

> I tried this, but it did not force the pivottable to display the entire range
> of dates. It displays only those dates for which there is actually data.
[quoted text clipped - 19 lines]
>>>only 3
>>>dates, but I want to see all 7 dates in the range.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message