Pivot Table with Data Added Monthly

[Guest]

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

 

[Roger Govier]

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/flashfiles/pivot1.html

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