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?