Pivot table

  • Thread starter Thread starter hall1734
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Filter Formula 1
including zero values in a pivot table 2
Pivot table missing customers 1
Pivot Table sum incorrect 3
Excel 2003 Pivot Table Issues 3
Date/Time issue with Pivot Table 3
Refreshing Pivot Table on a protected spreadsheet tab 1
pivot table to display the value instead of a summary 1

Back
Top