| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot Table with Zero Values for Month
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 |
|
#2
|
|||
|
|||
|
In the pivot table, double-click the Date field button
Add a check mark to the 'Show items with no data' box Click OK wyman wrote: 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am having problems creating pivot table of data | Charts and Charting in Excel | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
| Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
| create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Linear Mode
