| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you spread Pivot Table "Value" Fields in seperate columns
When multiple feilds are placed in the Values window of the pivot table setup
screen, the resulting data is stacked in one column. Can this data be spread into seperate columns? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you spread Pivot Table "Value" Fields in seperate columns
Try dragging that "Data" field and drop it over "Total" - this should
rearrange it into the columns format that you seek. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "rsnow" wrote: When multiple feilds are placed in the Values window of the pivot table setup screen, the resulting data is stacked in one column. Can this data be spread into seperate columns? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you spread Pivot Table "Value" Fields in seperate columns
This did not seem to work in Excel 2007
"Max" wrote: Try dragging that "Data" field and drop it over "Total" - this should rearrange it into the columns format that you seek. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "rsnow" wrote: When multiple feilds are placed in the Values window of the pivot table setup screen, the resulting data is stacked in one column. Can this data be spread into seperate columns? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you spread Pivot Table "Value" Fields in seperate columns
This did not seem to work in Excel 2007
I might have misunderstood your scenario. Don't have xl07, but maybe you could paste a sample of your pivot "as-is" and how you want it to become? -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "Dynamic" calculated fields in a pivot table | Excel Discussion (Misc queries) | |||
| Pivot Tables - Using "IF" function in calculated fields | Excel Discussion (Misc queries) | |||
| Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
| How to "blank" pivot table calculated fields if result = 0 | Excel Worksheet Functions | |||
Linear Mode
