Pivot question (2 parter)

  • Thread starter Thread starter hedrew3
  • Start date Start date
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
 
<<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
 
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
 

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

Similar Threads

add subtotals in columns in pivot table 2
pivot table showing row field with no value 1
Average of % in pivot table 1
Pivot Data 2
A calculated item gives unwanted changes to my pivot table 1
Calculated Field in Pivot Table 1
Sumproduct and CountA combined? Is that possible? 1
Excel 2007 Pivot Table Question 2

Back
Top