Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i change pivot layout
Greetings all Please view attached See how multiple related items for each individual record stack on top of each other as rows?? I would like to know if it is possible to show them in columns instead of rows, in a way that very basic drawing illustrates. +-------------------------------------------------------------------+ |Filename: screen.JPG | |Download: http://www.excelforum.com/attachment.php?postid=4865 | +-------------------------------------------------------------------+ -- marksince1984 ------------------------------------------------------------------------ marksince1984's Profile: http://www.excelforum.com/member.php...o&userid=33484 View this thread: http://www.excelforum.com/showthread...hreadid=549738 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i change pivot layout
I didn't open your file, but if you want to arrange the data fields
horizontally, drag the Data field button onto the cell that contains the word Total, as shown he http://www.contextures.com/xlPivot02.html marksince1984 wrote: Greetings all Please view attached See how multiple related items for each individual record stack on top of each other as rows?? I would like to know if it is possible to show them in columns instead of rows, in a way that very basic drawing illustrates. +-------------------------------------------------------------------+ |Filename: screen.JPG | |Download: http://www.excelforum.com/attachment.php?postid=4865 | +-------------------------------------------------------------------+ -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i change pivot layout
Debra Dalgleish Wrote: I didn't open your file, but if you want to arrange the data fields horizontally, drag the Data field button onto the cell that contains the word Total, as shown he http://www.contextures.com/xlPivot02.html BRILLIANT!! Thanks for the help, just what i needed! -- marksince1984 ------------------------------------------------------------------------ marksince1984's Profile: http://www.excelforum.com/member.php...o&userid=33484 View this thread: http://www.excelforum.com/showthread...hreadid=549738 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i change pivot layout
You're welcome! Thanks for letting me know that it helped.
marksince1984 wrote: Debra Dalgleish Wrote: I didn't open your file, but if you want to arrange the data fields horizontally, drag the Data field button onto the cell that contains the word Total, as shown he http://www.contextures.com/xlPivot02.html BRILLIANT!! Thanks for the help, just what i needed! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel 2000, How can I change the order in a pivot table? | Charts and Charting in Excel | |||
Change the color of cells in the pivot table | Excel Discussion (Misc queries) | |||
Change the color of some cells in the pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
How can I change the default settings for pivot tables in Excel? . | Excel Discussion (Misc queries) |