|Subject:||RE: Pivot Table Question|
|Date:||Fri, 19 May 2006|
Select "Average" from the drop down menu not "Percentage".
> 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
> 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?
Pivot Table Question posted by Derek on Fri, 19 May 2006