| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Heading on each row in pivot table
Is there a way to get the column data to be on each row in a pivot table,
excel 2003? For example, I would like the 1 to be on each of the account rows for territory 1. Thanks Sum of Sales Month Territory Account Jan Grand Total 1 Account 1 100 100 Account 2 200 200 Account 3 300 300 Account 4 400 400 1 Total 1000 1000 2 Account 5 500 500 Account 6 600 600 Account 7 700 700 Account 8 800 800 2 Total 2600 2600 Grand Total 3600 3600 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table Row heading appearing in duplicate in Excel 2003 | Excel Discussion (Misc queries) | |||
| Pivot Table, merge columns into one row heading? | Excel Discussion (Misc queries) | |||
| Pivot table heading | Excel Discussion (Misc queries) | |||
| Pivot Table Heading Fields - case sensitivity issue | Excel Discussion (Misc queries) | |||
| In a table produce an value by column heading and row heading | Excel Worksheet Functions | |||
Threaded Mode
