Determining answer rate for calls in call center

i have used a pivot table to pull the information
You have a % but what is that based on - what would be the total number to take a % of
would ALL dispositions be used

you can then add a filter to the disposition to remove the calls you do not want to see

You may need to add a formula to the table to work out the %
A formula to add a 1 for calls missed in the table using an IF( disposition = ??? , 1, 0)
and add that to the table - BUT again how would you work a % based on what ?

a Pivot table looks quite complicated - but it is very easy to setup and also much easier to update when you add new data

how is your data added to the sheet ?
or are you looking at the data for a specific period ?

you could add a date and then start to look at trends as well