ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot table calculations (https://www.excelbanter.com/excel-programming/396258-pivot-table-calculations.html)

Doug

Pivot table calculations
 
I have a pivot table with the following layout with hours being the data:

Elapsed Hours
Plant
Machine
Downtime Reason
Plant
Machine
Downtime Reason


I want to add a calculated field for % of downtime by reason, but can only
get it based on the report total instead of the subtotal. Is it possible to
do a calculated field by subtotal? Also I want to add a calculated field as
a % of hours available. The hours available is a constant amount in each
record my data source. When i try the '% of Base Amount' formatting I keep
getting a N/A value. What am i doing wrong?

Thanks in advance.


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

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