Pivot Table with Data Added Monthly
 

I have a worksheet that has 20+ columns in it, along with 500+ rows. Each row
contains a record for a given region, country, product - showing various
numbers and details. (Its currently missing a "date" column, but this can be
added)

Ignoring that I am adding to this data monthly, I already have 12 months
worth of data to import (hence the need for the "date" column). Once I bring
all 12 months in (including the month), I need to be able to :
- group, total and summarize the data by Region, then by Country, then by
product
- I'd like to be able to look at Regional totals by month or Country totals
by month

The tricky part now is, once I get that data, how do I create a pivot table
from the grouped data to show in various charts/graphs ?

Any direction would be fantastic.
Cheers,
JCH
--
Dawg House Inc.
"We live in it, therefore, we know it!"

Pivot Table with Data Added Monthly
 

Hi

Take a look at the following sites
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html

http://www.datapigtechnologies.com/f...es/pivot1.html

http://www.edferrero.com/Tutorials.aspx


--
Regards

Roger Govier


"Dawg House Inc" wrote in
message ...
I have a worksheet that has 20+ columns in it, along with 500+ rows.
Each row
contains a record for a given region, country, product - showing
various
numbers and details. (Its currently missing a "date" column, but this
can be
added)

Ignoring that I am adding to this data monthly, I already have 12
months
worth of data to import (hence the need for the "date" column). Once I
bring
all 12 months in (including the month), I need to be able to :
- group, total and summarize the data by Region, then by Country, then
by
product
- I'd like to be able to look at Regional totals by month or Country
totals
by month

The tricky part now is, once I get that data, how do I create a pivot
table
from the grouped data to show in various charts/graphs ?

Any direction would be fantastic.
Cheers,
JCH
--
Dawg House Inc.
"We live in it, therefore, we know it!"