Pivot Tables - Reporting Null Values

  • Thread starter Thread starter Winshent
  • Start date Start date
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
 
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
 
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
 
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...
 
Back
Top