Creating Calculated Field with SUM and COUNT of Fields Pivot Table

Here's a snapshot of my pivot table.

I want to create a calculated field that displays the percentage from the Responded column (C) over the Ticket # column (B) as in column G.

The Ticket # column is a column of value text strings (e.g. 413456, 464313) and the Responded column is a list of 1's and 0's. In my pivot table I am taking the count of all Ticket # and the sum of the Responded.

I tried to create a calculated field with the following formula

=Responded/COUNT('Ticket #')

but this gave me the same as Sum of Responded. How can I create a field that gives me the % in column G?

- - , .
.

Recent Questions...