Pivot Tables and Trend Data

T

TKrepitch

I have a data table that lists products down Column A. Columns B
through P have characteristics of each of those products. Beginning
in Column Q are monthly numbers. That is, Column Q has month 1
numbers, Column R has month 2 numbers, etc.

I am trying to set up pivot tables that will show me averages of the
monthly numbers depending on which characteristics I choose. For
example, I want to compare the trend in sales for all products that
are white versus all products that are black.

How do I set up the pivot table to show trends? Obviously, I need to
name a data field and a column field, but if I put the months in the
data field, it won't show the trend by month. Do I need to set up my
data table differently? Maybe use two tables? Thanks!
 
K

Kevin Labore

When I used pivot tables for reporting information I would prefer to have
them in the following format:

ColQ - ColS Should have year, Month, Day( if needed)
That way you can pivot based on those Col headers.
You can compare this month to LY (or prior years if need) or just compare
this month to last and other prior Month,
You can also do a pivot chart or regular chart based on the pivot table.

The Problem with having the data arrange the way you explained it is more
difficult to pivot data IMHO
I would set up the data table differently to make it easier to PIVOT

HTH
Kevin
 
T

TKrepitch

When I used pivot tables for reporting information I would prefer to have
them in the following format:

ColQ - ColS Should have year, Month, Day( if needed)
That way you can pivot based on those Col headers.
You can compare this month to LY (or prior years if need) or just compare
this month to last and other prior Month,
You can also do a pivot chart or regular chart based on the pivot table.

The Problem with having the data arrange the way you explained it is more
difficult to pivot data IMHO
I would set up the data table differently to make it easier to PIVOT

HTH
Kevin








- Show quoted text -
Click to expand...

Thanks, Kevin. I will try that. :)
 
Top