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