View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default 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