Pivot Tables - Sum then Average

M

Michael

Ok I data by location and by year..

We'll say Philly, NY, LA - 2009, 2008, 2007

In each year there is multiple enteries for each location in the
source data:

2007-philly-$1,000
2007-philly-$300
2007-Philly-$500

etc

This is what I need and I can get it, but I'm wondering if there is a
way to do it within the pivot table:

First I want to see the totals by location, by year:

2007-Philly-$1,800
2008-Philly-$300
2009-Philly-$1,000
etc

Then I want to know how much each location averages per year. (ie
$1,800+$300+$1,000 / 3)


If I change the function of the pivot table to average, it will give
me the average transaction per year and then the average transaction
overall.

I want the average total by location, by year.

Thank you.
 
T

trip_to_tokyo

Ok I data by location and by year..

We'll say Philly, NY, LA - 2009, 2008, 2007

In each year there is multiple enteries for each location in the
source data:

2007-philly-$1,000
2007-philly-$300
2007-Philly-$500

etc

This is what I need and I can get it, but I'm wondering if there is a
way to do it within the pivot table:

First I want to see the totals by location, by year:

2007-Philly-$1,800
2008-Philly-$300
2009-Philly-$1,000
etc

Then I want to know how much each location averages per year. (ie
$1,800+$300+$1,000 / 3)

If I change the function of the pivot table to average, it will give
me the average transaction per year and then the average transaction
overall.

I want the average total by location, by year.

Thank you.

Which version of the software?
 

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

Top