Forum Discussion
Pivot table > calculated fields
Any one knows why 1 field is showing zero in Pivot? formula in calculated fields are correct. all columns showing data correctly except 1 column
I've attached the screenshot of the pivot
HelloCathy That formula does not take the count of transfers divided by the count of handles. It takes the total of all transferred divided by the total handled. Difficult to explain. Would need the data to demonstrate without guessing.