Forum Discussion
Using calculated columns in pivot table
I already used calculated fields to get some datas in my pivot table. They're displayed as count or sum. I want to make a new calculated fields using a Sum of working time, divide it with the number ...
maybe I'm missing something but isn't that just Average of working time? So on the 'Field List' add Working Time to the Value section a second time and go to 'Value Field Settings' and change calculation to Average (then you can also change the Name also).