Pivot Table Page Layout Questions

[Guest]

I am trying to place three columns of data in a pivot table. However
whenever i drag over the three different items into the data view it postions
them going down the column not across several columns like I want. I have
selected the Over , then Down option in the Table Layout and set the Fields
per Row equal to 1. I thought this would do the trick but it is still
putting my fields down the column versus across columns.

Also, does anyone know if the column totals for a given field (like Sum or
Count) can be shut off for individual fields? Seems like either all the
Fields totals are turned off or on.

Thanks much,

 

[Debra Dalgleish]

In the pivot table, drag the Data button onto the cell that contains the
word Total. There's a picture here:

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

You can't turn off column totals for a specific column.