From: Elan lent on
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
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
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