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.
<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>
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>