Forum Discussion
PivotTable - Calculated Field Subtotal
I inserted in a calculated field into a pivot table that multiplies 2 values (this field is titled "sum of Prod Routing Hrs" in the table (see screenshot) and the automatic subtotal on the date (in t...
This is a limitation of calculated fields. Better to either add the calculation next to your source data (if possible) or to use a measure in PowerPivot.