date series in PivotTables

K

KFuda

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

Barb Reinhardt

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

Roger Govier

Hi

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

KFuda

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

Debra Dalgleish

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
 
Top