#1
|
|||
|
|||
Show Items with no data
I have a pivot table where I plot trends over time and want the months with no data to show in my pivot table. I have selected the "Show Items with no data" in the Field Settings and it shows the missing months. However, this has created a problem. I also only want to show certain years so I normally would filter by years (2010 and 2011 only, for example) but when I do this all the months for all the years (2009 thru 2011) under each year. For example:
2010 2011 Jan09, Feb09.......Nov11, Dec11, Jan 09, Feb09, ......Nov11, Dec11 I don't want any 2009 columns to show at all and I don't want the other year's months to show under the selected year, for example I don't want 2009 or 2010 months to show under 2011. (Note: It does not pull data, it shows as a "0" but it still has the column headings) How do I get the Pivot table to show all the months, even if they don't have data for that month, but not do what I described above? Thank you |
#2
|
||||
|
||||
Hi
it seems you are not working with real dates. Maybe post a small sample of your data and your PT so one can see the formatting, etc...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
data, pivot, show |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Powerpoint: adding data to trend lines w/o data labels | HaiLe | PowerPoint | 0 | 04-11-2011 09:21 AM |
Question: Hyperlink to other show, but close the current show | habibfikri | PowerPoint | 0 | 12-26-2010 02:37 AM |
PP 2010 .avi file plays during slide show, but causes the slide show to loop to begin | VictorS | PowerPoint | 0 | 10-16-2010 10:23 AM |
Show different Data depending on Imput Value | Aton | Word | 0 | 09-15-2010 03:43 AM |
Outlook 2007 Saved sent items list only holds the last ten items | david.peake | Outlook | 0 | 06-01-2010 07:27 PM |