|
Pivot Table with Multiple Row Fields
I know pivot tables are used to summarize information, but for my application
I need to fill in. e.g. (Normal Pivot) Item Desc Region Week 1 Week 2 Week 3 XXXX XXXX XXXX XX XX XX XXXX XX XX XX XXXX XX XX XX XXXX XX XX XX (Would Like) Item Desc Region Week 1 Week 2 Week 3 XXXX XXXX XXXX XX XX XX XXXX XXXX XXXX XX XX XX XXXX XXXX XXXX XX XX XX XXXX XXXX XXXX XX XX XX Region is made up of many stores, so even though it has item and desc on every line it is still rolled up from store to region level. |
The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. To create the table with a heading on each row, you can copy the table, paste it as values in another location, and fill the blanks: http://www.contextures.com/xlDataEntry02.html Matt Cromer wrote: I know pivot tables are used to summarize information, but for my application I need to fill in. e.g. (Normal Pivot) Item Desc Region Week 1 Week 2 Week 3 XXXX XXXX XXXX XX XX XX XXXX XX XX XX XXXX XX XX XX XXXX XX XX XX (Would Like) Item Desc Region Week 1 Week 2 Week 3 XXXX XXXX XXXX XX XX XX XXXX XXXX XXXX XX XX XX XXXX XXXX XXXX XX XX XX XXXX XXXX XXXX XX XX XX Region is made up of many stores, so even though it has item and desc on every line it is still rolled up from store to region level. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Debra -
Thank You. I used the macro and it worked perfectly. Good to know the GoTo function as well. Have a great day! "Debra Dalgleish" wrote: The row headings show once in a Pivot Table, and there's no setting you can change, to force them to repeat. To create the table with a heading on each row, you can copy the table, paste it as values in another location, and fill the blanks: http://www.contextures.com/xlDataEntry02.html Matt Cromer wrote: I know pivot tables are used to summarize information, but for my application I need to fill in. e.g. (Normal Pivot) Item Desc Region Week 1 Week 2 Week 3 XXXX XXXX XXXX XX XX XX XXXX XX XX XX XXXX XX XX XX XXXX XX XX XX (Would Like) Item Desc Region Week 1 Week 2 Week 3 XXXX XXXX XXXX XX XX XX XXXX XXXX XXXX XX XX XX XXXX XXXX XXXX XX XX XX XXXX XXXX XXXX XX XX XX Region is made up of many stores, so even though it has item and desc on every line it is still rolled up from store to region level. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
You're welcome! Thanks for letting me know that the macro helped.
Matt Cromer wrote: Debra - Thank You. I used the macro and it worked perfectly. Good to know the GoTo function as well. Have a great day! "Debra Dalgleish" wrote: The row headings show once in a Pivot Table, and there's no setting you can change, to force them to repeat. To create the table with a heading on each row, you can copy the table, paste it as values in another location, and fill the blanks: http://www.contextures.com/xlDataEntry02.html Matt Cromer wrote: I know pivot tables are used to summarize information, but for my application I need to fill in. e.g. (Normal Pivot) Item Desc Region Week 1 Week 2 Week 3 XXXX XXXX XXXX XX XX XX XXXX XX XX XX XXXX XX XX XX XXXX XX XX XX (Would Like) Item Desc Region Week 1 Week 2 Week 3 XXXX XXXX XXXX XX XX XX XXXX XXXX XXXX XX XX XX XXXX XXXX XXXX XX XX XX XXXX XXXX XXXX XX XX XX Region is made up of many stores, so even though it has item and desc on every line it is still rolled up from store to region level. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| All times are GMT +1. The time now is 03:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com