Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dan Reynolds
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I show summary totals from a pivot table on a bar chart Colleen T Charts and Charting in Excel 5 January 22nd 05 02:41 AM
Pivot Table with Zero Values for Month wyman Charts and Charting in Excel 1 January 14th 05 06:59 PM
I am having problems creating pivot table of data wyman Charts and Charting in Excel 1 January 12th 05 06:17 PM
Using Microsoft Query data in a pivot table. slapana Charts and Charting in Excel 0 January 11th 05 06:03 PM
changing proportion of chart and data table Dawn Parks Charts and Charting in Excel 3 January 6th 05 02:18 AM


All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"