Pivot table
 

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.

Pivot table
 

Use multiple consolidate ranges option in pivot table.



On Apr 8, 12:17*am, hall1734
wrote:
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.

Pivot table
 

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

hall1734 wrote:
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.


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