Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
in a pivot table, can the average include blank entries?
I have a pivot table set up to tell me how many hours were incurred during
each month before an event. (Eg. 5 Month Prior: 152 hours, 4 Month Prior: 38 hours.) If no hours are incurred, my data sheet does not show zero, it just doesn't have anything. I set the Total Row to be an average of the data, but the average doesn't pick up records with no hours incurred. (If one program had no hours, the average will not include that as being zero, it just excludes it from the average) Is there a way to have blank entries included in the average? (I already have empty cells set to display 0) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
count of (blank) pivot table | Excel Discussion (Misc queries) | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Pivot Table -- Add column to average Grand Total | Excel Worksheet Functions | |||
In excel and a pivot table - how can I stop it displaying (blank). | Excel Discussion (Misc queries) |