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

Replies

None

In response to

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