| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Group by Month when no data
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 -- GLS |
| 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
