Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table - Group by Month - Show Items with no data
Greetings
My data is in financial year, July to June. The date field is in the format DD/MM/YYYY which is in the column area of the pivot table. I have this grouped by month and year, so it displays Jul-Dec 2003, followed by Jan-Jun 2004. Some items in the "Row" area of the table do not have entries for all 12 months, but I still want to display the month for that item (with no data). In the "field settings" of month I have selected "show items with no data". Unfortunately this then displays Jan-Jun for 2003 and Jul-Dec for 2004, all blank because those dates are not in the financial year I am reporting on - and I don't want to see those months at all. how can I just show 03/04 months (even if there is no data in them) and not 02/03 or 04/05 months? thanks in advance Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
Pivot Table with Zero Values for Month | Charts and Charting in Excel | |||
I am having problems creating pivot table of data | Charts and Charting in Excel | |||
Using Microsoft Query data in a pivot table. | Charts and Charting in Excel | |||
changing proportion of chart and data table | Charts and Charting in Excel |