Pivot Tables and row level output

[Rich]

I am using Excel 97.

When I do a pivot table, the summed values are all in one column. I
want to have the output go into a row. Below is an example of what I
get now. And what I want the result to be.

Now :

Acct # Data Total
123 Sum of value1 $10
Sum of value2 $20


What I want :

Acc # Sum of Value 1 Sum of value 2
123 $10 $20

 

[Debra Dalgleish]

Drag the Data field button onto the cell that contain the word Total.
There's a diagram here:

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