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,

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

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

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


Lee wrote:
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
Contextures
http://www.contextures.com/tiptech.html