Pivot Table with Data Added Monthly


G

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
 
Ad

Advertisements


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