Pivot question (2 parter)

H

hedrew3

I have four columns: Category, Year, Month, and Amount.

When I do a pivot table, I would like to have the Year and Month
appear horizontally across; right now, I can only get it to show
vertically.

I would like to consolidate some of the categories and call it
"Others," rather than showing all of the details for those categories.
What is an easy way to do this?

TIA

Pete
 
B

BrianB

<<Year and Month appear horizontally across>>
drag your month field to the COLUMN area in the wizard.

<<I would like to consolidate some of the categories >>
You will have to make another column to contain "Other" in place of th
categories not required. This is not a problem (you can use a formul
or do the job manually by sorting), and a good principle for havin
numerous ways of displaying data
 
H

hedrew3

BrianB said:
<<Year and Month appear horizontally across>>
drag your month field to the COLUMN area in the wizard.

<<I would like to consolidate some of the categories >>
You will have to make another column to contain "Other" in place of the
categories not required. This is not a problem (you can use a formula
or do the job manually by sorting), and a good principle for having
numerous ways of displaying data.
Click to expand...

Thanks for your pointers.

Pete
 
Top