View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bendinblues Bendinblues is offline
external usenet poster
 
Posts: 16
Default pivot tables - number of columny but need a column for each month

A pivot table gets refreshed weekly and this pivot table is a source for
other calculations that rely on the presence of a column of data for each
month. Currently, if the source data does not contain value for April, for
example, then the column for April does not exist in the pivot table. This
scews up the relative reference used in the calculation of summary data. If
there is nor data for April, then the number 0 should appear.

Can anyone help?