RE: Pivot Table Question

Giganews Newsgroups
Subject: RE: Pivot Table Question
Posted by:  jjenkins
Date: Fri, 19 May 2006

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?
> Derek



In response to

Pivot Table Question posted by Derek on Fri, 19 May 2006