Hi,

I would like to have a calculated field in pivot table to calculate the percentage of (sum of TAT/ count of items). However, if I insert the formula in calculated field as
Count(ClaimNumber)/Sum(Curr_TAT), I will get value 1.

Name Count of ClaimNumber Sum of Curr_TAT % of TAT (Count of items/sum of tat)
XXX 6685 1 0.01%
YYY 6137 1 0.02%

Thanks,
Apple