Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2012, 11:59 AM
DeborahBartlett DeborahBartlett is offline Show Items with no data Windows XP Show Items with no data Office 2007
Novice
Show Items with no data
 
Join Date: Jan 2012
Posts: 2
DeborahBartlett is on a distinguished road
Question 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
Reply With Quote
  #2  
Old 01-24-2012, 01:10 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Show Items with no data Windows XP Show Items with no data Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft