W
Woodsy
I have a PivotTable report that breaks out hours worked (data) by project
worked on (row) and month hours were worked (column). I can easily add a
grand total column to the end of the pivottable by selecting the month field
and clicking the subtotal button on the toolbar. How can I change/edit this
subtotal column or add a new column that calculates a total average hours
worked for all the months in question? In other words, I have data from
Jan-Jun and a grand total of this data. I need an average column for this
data as well, ideally one that counts blank fields as "0" values, so if
Jan-May had data and June had 0 hours worked (blank), it would stillb e
factored into the average.
worked on (row) and month hours were worked (column). I can easily add a
grand total column to the end of the pivottable by selecting the month field
and clicking the subtotal button on the toolbar. How can I change/edit this
subtotal column or add a new column that calculates a total average hours
worked for all the months in question? In other words, I have data from
Jan-Jun and a grand total of this data. I need an average column for this
data as well, ideally one that counts blank fields as "0" values, so if
Jan-May had data and June had 0 hours worked (blank), it would stillb e
factored into the average.