View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Brown[_6_] Gary Brown[_6_] is offline
external usenet poster
 
Posts: 126
Default 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.