|Subject:||Pivot Table Question|
|Posted by:||Derek (der…@NOSPAMgfx.co.uk)|
|Date:||Fri, 19 May 2006|
This should be easy but I can't seem to get Excel to do it.
I have an input file with 5 columns
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?