Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update a Pivot Table with new data added to the base data | Excel Discussion (Misc queries) | |||
Pivot table with added columns for evaluating results | Excel Worksheet Functions | |||
pivot chart colors- how to keep from changing when data elements are added/removed? | Charts and Charting in Excel | |||
Added new columns - Pivot Table not refreshing - why? | Excel Worksheet Functions | |||
Pivot Table problem, blank fields aren't being added | Excel Discussion (Misc queries) |