Pivot Table Question

[Derek]

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

 

[Guest]

Derek,
On the field in question that show the sum of percentages. Right click and
select "Feild Settings" in that dialog you want to select percentage from the
drop down menu.
I think that's what you need. Not sure... good luck.

 

[Guest]

Select "Average" from the drop down menu not "Percentage".