Pivot Table Orientation
 

I'm trying to set up a pivot table with the Job Number in the column field
and total job costs and total job revenues in the data fields. But I want the
revenues and costs side by side rather than on separate rows. Do I need to
accomplish this with a macro?

Thanks.

Pivot Table Orientation
 

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


r wilcox wrote:
I'm trying to set up a pivot table with the Job Number in the column field
and total job costs and total job revenues in the data fields. But I want the
revenues and costs side by side rather than on separate rows. Do I need to
accomplish this with a macro?

Thanks.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html