![]() |
|
|
|
#1
|
|||
|
|||
|
First of all, I just began to learn about Pivot Tables on my own; so , please excuse my elementary question(s). I am using Excel 2010. My Data field have the months of Jan, Feb, Mch and Apr. Each month has expenses- Exp1, Exp2 & Exp3. I want to create a Pivot Table that reports the following information: Jan Feb Mch Total Exp1 $$ $$ $$ $$ Exp2 $$ $$ $$ $$ Exp3 $$ $$ $$ $$ I am using a filter to select the months (the data field also has APR). Question: How do I get the months selected (i.e., I want to exclude Apr)to also appear as columnar headings? I place the field "Month" in the Filter Box but I can't make the months appear as columnar headings? It appears that you cannot have a data field appear in more than one box ( i.e., Filter, Row Heading,Columnar Heading, etc.) Is that correct? |
|
| Tags |
| column headings |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot table help | TishyMouse | Excel | 2 | 04-27-2012 10:19 AM |
pivot table
|
aliasadi_07 | Excel | 1 | 03-11-2012 12:49 AM |
Help with a pivot table please!
|
natsha | Excel | 1 | 02-16-2012 12:41 PM |
Pivot Table
|
Karen615 | Excel | 5 | 08-03-2011 10:46 AM |
| Pivot Table Refresh | tpcervelo | Excel | 0 | 09-14-2010 06:54 AM |