| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables - Column Fields | Excel Discussion (Misc queries) | |||
| Decreasing number of Values in Pivot Tables Value List | Excel Discussion (Misc queries) | |||
| Default Number Format - Pivot Tables | Excel Discussion (Misc queries) | |||
| Pivot tables - text rather than number? | Excel Worksheet Functions | |||
| Is there a limit number of characters for cells in pivot Tables? | Excel Discussion (Misc queries) | |||
Threaded Mode
