| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
| How do I set up filter for page fields in pivot table? | Excel Discussion (Misc queries) | |||
| pivot table question, sum fields? | Excel Worksheet Functions | |||
| copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
| Is there an autofill for all row fields in a pivot table? | Excel Worksheet Functions | |||
Linear Mode
