Pivot table summary by rows possible?

Packman

New Member
Joined
Oct 6, 2006
Messages
4
I have data organized with the first 5 columns representing attributes and the next 12 columns showing data by month.

The first 5 columns are:
Category
Sub Category
Product Type
Pack Type
Org / Conventional

The next 12 columns are projected volumes by month.

What I want to be able to do is display summary information by various combinations of the first 5 columns columns by month. For example, I would want to see the data by category and Org/Conventional by month.

Is a pivot table the right way to do this or is there another solution?

Thanks!

(and great board by the way. I'll be a frequent visitor)
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
Hope I've picke dyou up right - can you not put the first 5 columns into the page field instead of the row field.

You will then get drop down boxes for each category and you can modify the views as you please
 

Packman

New Member
Joined
Oct 6, 2006
Messages
4
Well, I can do that but it still gives me the wrong info.

The problem I am having is that my data is already arranged by month. So when I go to put in the pivot table, it is asking for the data field to summarize.

In my data, the 12 months of data doesn't necessarily have a label other than the month heading. Under each month is projected volumes but I don't have a projected volumes heading but 12 columns with volume by month.

Hope that makes sense...
 

Forum statistics

Threads
1,141,681
Messages
5,707,791
Members
421,527
Latest member
Tamiwsw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top