Pivot Table Question

Giganews Newsgroups
Subject: Pivot Table Question
Posted by:  Derek (der…@NOSPAMgfx.co.uk)
Date: Fri, 19 May 2006

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

Replies