Pivot table show all days of a month even if no data
 

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.

Pivot table show all days of a month even if no data
 

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.

Pivot table show all days of a month even if no data
 

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.racks.../04_15_10.xlsm
Pdf preview:
http://www.mediafire.com/file/1wgfm0nym4w/04_15_10.pdf