Pivot table show all days of a month even if no data
in [Functions]
|
From: Elan lent on 15 Apr 2010 09:36 Hello, My question is the following. If i have data based on date (days). How to show all the days of the month even if there is no data for some days in the month ? I have a hole in pivot table ! Thank you in advance for your help.
From: Gary Brown on 15 Apr 2010 11:03 start off the pivot table data with blank records of all the dates in the range you want. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Elan lent" wrote: > Hello, > > My question is the following. If i have data based on date (days). > How to show all the days of the month even if there is no data for some days > in the month ? > I have a hole in pivot table ! > > Thank you in advance for your help. >
From: Herbert Seidenberg on 15 Apr 2010 21:30 Excel 2007, PivotTable Show all days in time range, including days with no data. No extra helper rows needed. Animated, with macro. http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_15_10.xlsm Pdf preview: http://www.mediafire.com/file/1wgfm0nym4w/04_15_10.pdf
|
Pages: 1 Prev: VLOOKUP & IF Next: creating a report from a table, pivot table not suitable |