PivotTable Help Please

[brentwoodcrew]

Hello y'all - I have what I think is an easy question, which I hope I can articulate it in a way that makes sense.

When creating a PivotTable in Excel 2010, how do I make two rows of column headers?
Below is what I am looking to create, except in PivotTable form.

Thanks for any help you're able to provide.

	Bill	Ronald	Paul	Frankenstein	Chevy Chase
Date	Sales	% Change	Sales	% Change	Sales	% Change	Sales	% Change	Sales	% Change
2008	$ 571,253,887		$ 272,971,007		$ 108,609,605		$ 60,775,525		$ -
2009	$ 512,959,694	-10.20%	$ 176,947,462	-35.18%	$ 84,375,220	-22.31%	$ 64,811,093	6.64%	$ 4,316,872
2010	$ 474,481,866	-7.50%	$ 223,310,892	26.20%	$ 103,434,521	22.59%	$ 56,611,120	-12.65%	$ 5,249,347	21.60%
2011	$ 459,607,218	-3.13%	$ 239,258,825	7.14%	$ 99,157,743	-4.13%	$ 58,075,344	2.59%	$ 15,273,372	190.96%
2012	$ 444,500,668	-3.29%	$ 249,277,192	4.19%	$ 85,589,041	-13.68%	$ 57,573,383	-0.86%	$ 20,841,317	36.46%

<colgroup><col style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;" width="35"> <col style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;" span="3" width="103"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;" width="95"> <col style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;" width="103"> <col style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;" width="87"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;" width="95"> <col style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" width="67"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;" width="95"> <col style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" width="67"> <tbody>
</tbody>

 

[ChrisM]

In pivot table terms, that is only one row of column headers. In your pivot window, put Name in the column section, then put Sales$ in the Value section. make sure Sales is set to SumOf. Then drag another copy of Sales and put it also in the Value section. Right click this one and work your way through the properties settings. There are options in there where instead of Count or Sum you can do % deltas vs. prior period.

 

[brentwoodcrew]

Thanks for the response. Unfortunately, I still can't seem to format it correctly. I am able to create a pivot table with the sales and % change columns, but I am still having trouble grouping those columns together under a single name. How do I get a 'Names' to apear in the pivot window?

 

[ChrisM]

Are you working in the "Field List" window? All you need to do is drag "Names" to the columns section.