PivotTable Help Please

brentwoodcrew

New Member
Joined
Jan 9, 2014
Messages
2
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.

BillRonaldPaulFrankensteinChevy Chase
DateSales% ChangeSales% ChangeSales% ChangeSales% ChangeSales% 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>
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

ChrisM

Well-known Member
Joined
Jun 11, 2002
Messages
2,129
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

New Member
Joined
Jan 9, 2014
Messages
2
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

Well-known Member
Joined
Jun 11, 2002
Messages
2,129
Are you working in the "Field List" window? All you need to do is drag "Names" to the columns section.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,600
Messages
5,597,113
Members
414,125
Latest member
iQQ

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top