Forum Discussion
Solved
Calculated Field in Pivot Table Not Summing Correctly
Hi, all. I have a pivot table that has a calculated field in the last column of the pivot table. The formula I am using is an IF formula to determine Full Time Equivalents. I was hoping it would a...
With calculated field in total PivotTable uses the same formula as for the rows, not sum them. Thus if your IF() applied to totals returns 1, in grand total for FTE will be 1.
For such calculations it's better to add data to data model creating PivotTable and use DAX measures for aggregations.
It occurs to me to ask also what the IF formula is testing for, and what its result is in connection with the FTE question. But truly, most helpful: post the actual workbook, devoid of confidential data.