Pivot Tables

[Guest]

I have two spreadsheets and a pivot on each spreadsheet - the layout is exactly the same yet the output is different. How can I make them exactly alike. One has "data" listed Pric
Uni
Tota
and one has "data" listed Price Unit Tota
How can I get the data to list across instead of down?

 

[Debra Dalgleish]

Drag the Data field button onto the cell which contains the word
'Total', and the fields will be arranged horizontally. There are
instructions here:
http://www.contextures.com/xlPivot02.html

 

[Guest]

Thank you so much! Boy was I frustrated with that yesterday. Works like a champ.