If you drag the Data button onto the cell that contains the word Total,
the data fields will be arranged horizontally. There's a picture he

http://www.contextures.com/xlPivot02.html

Excel GuRu wrote:
I'm new to pivot tables and am trying to find ways to use them.

Is it possible to have multiple fields of "Data" appearing horizontally so
it is easy to compare? I'm thinking of data that includes dollars,
percentages, and sales units. When these items appear vertically and sum,
they are meaningless and hard to analyze.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html