empty pivot table fields

B

bobf

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
 
D

Debra Dalgleish

Right-click on the Weeks field button.
Select Field Settings
Add a check mark to 'Show items with no data'
Click OK
 
Top