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

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

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

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