Prev: If or conditional formatting?
Next: SUMIF date criteria
From: alberto on 15 Dec 2009 13:10
I have a table with region, leaders (rows), points per leader (value), and
date (column).

I want to get the average number of points per region per day.

If I summarize the data using sum, I get the total number of points, not the
average.
If I summarize the data using average, I get the average number of points
per person per day, not the average numer of points of the region per day.

What need is to divide the total number of points of each region, each day,
by the number of persons that actually get points that day.

Any ideas?



From: ryguy7272 on 15 Dec 2009 13:25
You may have to add a helper column and do the calculation in that column.
Pivot Tables are great, but sometimes you are restricted in how you can
manage your data. Although, if you add in more data, you can manage that in
the Pivot Table.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"alberto" wrote:

> I have a table with region, leaders (rows), points per leader (value), and
> date (column).
>
> I want to get the average number of points per region per day.
>
> If I summarize the data using sum, I get the total number of points, not the
> average.
> If I summarize the data using average, I get the average number of points
> per person per day, not the average numer of points of the region per day.
>
> What need is to divide the total number of points of each region, each day,
> by the number of persons that actually get points that day.
>
> Any ideas?
>
>
>
From: Herbert Seidenberg on 15 Dec 2009 23:43
Excel 2007 PivotTable
With helper column as per ryguy7272.
http://www.mediafire.com/file/jrdnm3ynloz/12_15_09.xlsx
 | 
Pages: 1
Prev: If or conditional formatting?
Next: SUMIF date criteria