Pivot Table with Zero Values for Month

W

wyman

I have a spreadsheet of information that lists problems experienced by
'application type' for each month in 2004. When I create a pivot from this
data, where any particular 'application type' did not have a problem and,
hence, no entry in the spreadsheet, the pivot does not display this at all.
How can I get it to display this as 'zero' so that I get a full January -
December trend? Thanks
 
D

Debra Dalgleish

In the pivot table, double-click the Date field button
Add a check mark to the 'Show items with no data' box
Click OK
 

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

Creating a Chart on form from selected data in query. 0
pivot table missing rows? 0
Excel 2007 charts: want to avoid zero values 1
Split form 0
Pivot table Days to Months 0
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
Formula to Look up values from a pivot table 1
Pivot Tables drag & drop 2

Top