empty pivot table fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I force a pivot table to, for example, say that there were no
accidents in week 2. At present it says 3 in week 1 then jumps to 2 in week
3. I want week 2 =0 for charting purposes. -thanks
 
Right-click on the Weeks field button.
Select Field Settings
Add a check mark to 'Show items with no data'
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 Dates 1
Pivot Table/Conditional Formatting Guru Help 2
Information for Pivot Table 3
Pivot Table Filter Formula 1
SUMIF/AND combination? 2
pivot table help 1
always display rows in Pivot tables (show items with no data) 1
Question on the occupied field of the pivot table in excel spreadsheet 0

Back
Top