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) |
All times are GMT +1. The time now is 05:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com