I have tried that but it still doesn't add up correctly.

Maybe I'm doing something wrong with the way I am setting up the Pivot
Table.

I've tried attaching the spreadsheet, can you see anything that is obviously
wrong?

Thanks again,
Derek


"jjenkins" wrote in message
...
Select "Average" from the drop down menu not "Percentage".

"Derek" wrote:

Hi folks,

This should be easy but I can't seem to get Excel to do it.

I have an input file with 5 columns

Date
Branch
Count Of Calls Fixed in Target
Count Of Total Calls
Percentage Of Calls Fixed In Target

I convert to a pivot table and put the 3 number fields into the Data
block.
Date forms the Columns
Branch forms the Rows

For individual records its shows fine, but for Totals and Sub Totals the
percentages are all wrong. It is doing a sum of the percentages rather
than
a percentage of the sums.

Just can't figure out how to make it work correctly

Can anyone help?

TIA
Derek