| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Right-click the Date field button
Choose Field Settings Add a check mark to 'Show items with no data' Click OK GLS wrote: I have a series of pivot tables set up as one report to show data activity per month, however, some months there is no data and the month is excluded from the table. This means the month are out of line on the different tables from each other. How can I set it up so that when there is no data that month it will show Zero or blank? Many thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Threaded Mode
