ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Average Summary Not Working (https://www.excelbanter.com/excel-discussion-misc-queries/236391-average-summary-not-working.html)

Visakha

Average Summary Not Working
 
My pivot table set up like this:
Column A is staff name
Col B is hours worked
Col C is hours billed
Col D is productivity

The productivity for each staff comes out accurate but the summary does not.
The result I am looking for is total hours worked, total hours billed and
productivity (billed/worked hrs). I tried custom calculation and also tried
having 2 subtotals (one for sum and one for average) but still can't get the
productivity for all staff correct. Advice?


All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com