Pivot Tables - Reporting Null Values

W

Winshent

I am creatind a weekly report on mail despatched.

Need to report on a day by day basis ie with the days along the top.
The data is a simple log of two columns:- Date Sent, Service
Level(mail despatched within 2 working days)

there will be days when no mail will be despatched. How do i get these
into a pivot table? was thinking i should create a seperate list of
each day. but not sure how to build this into the pivot table.

Any help would be much appreciated.

Many thanks

Vincent
 
D

Debra Dalgleish

Right-click on the date field, and choose Group and Show Detail > Group
Group by Year, Month and Day
Click OK
Double-click on the date field
Add a check mark to 'Show items with no data', click OK
 
W

Winshent

Debra

Thanks for your response. This still presents the problem as if there
is no data for the first day that i want to report on then there is no
way of forcing the pivot table to return a null value for the day.

I have solved this temporarily by inserting records with no data for
all the days of the week. Surely there is a better way of doing this
though?

Vincent
 
D

Debra Dalgleish

None that I know of.
Debra

Thanks for your response. This still presents the problem as if there
is no data for the first day that i want to report on then there is no
way of forcing the pivot table to return a null value for the day.

I have solved this temporarily by inserting records with no data for
all the days of the week. Surely there is a better way of doing this
though?

Vincent
Click to expand...
 
Top