Excel Pivot Tables-How to put two Data Varibles side by side
 

Does anyone know how to put to data variable side by side? Like Name in row
and age and weight in the data field, where they would show in the Pivot
table ...

Name Age Weight
Will 30 170
Joe 25 159

Excel Pivot Tables-How to put two Data Varibles side by side
 

I don't know if this is what you are asking about but if your data
looks like this:

Name Data Value
Will Age 30
Will Weight 170
Joe Age 25
Joe Weight 159

Then when you create a pivot table of that data it will look like this:
Name Age Weight
Will 30 170
Joe 25 159

which is the example you posted before.

Cheers,
Jason Lepack

BillyBob wrote:
Does anyone know how to put to data variable side by side? Like Name in row
and age and weight in the data field, where they would show in the Pivot
table ...

Excel Pivot Tables-How to put two Data Varibles side by side
 

Add both amount fields to the pivot table's data area
Then, drag the Data button onto the cell that contains the word Total.

There's a picture he

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

BillyBob wrote:
Does anyone know how to put to data variable side by side? Like Name in row
and age and weight in the data field, where they would show in the Pivot
table ...

Name Age Weight
Will 30 170
Joe 25 159

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