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,