Pivot Tables - Sum then Average

  • Thread starter Thread starter Michael
  • Start date Start date
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.
 
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.
Click to expand...

Which version of the software?
 
Back
Top