Pivot Tables - get a total different than the summarize field sett

A

alberto

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot tables - total different than the summarize function 0
pivot tables - totals different than the summarize function 1
pivot table - get the average of a field 1
Pivot Tables - Sum then Average 1
Average of top x% of a list 1
Average a group of numbers within an date range. 4
Arrays and Average 3
Dynamically sized table compiled from unsorted rows with blank entries 2

Top