Pivot table

H

hall1734

I would like to use a pivot table to summarize data for expense reports.
Users like seeing the week summarized so they can quickly see if something is
left out. I don't know how to get all seven days of the week to show even if
there is no data for that day.
 
D

Debra Dalgleish

In the pivot table, right-click on the Date field button
Click Group and Show Detail, then click on Group
Group by Days, with the Number of days as 7, then click OK

Right-click on the Date field button
In the PivotTable Field dialog box, add a check mark to 'Show items with
no data', then click OK
 
Top