Pivot Tables - Putting Additonal Data items beside each other.

[Jim Moberg]

We are using a pivot table to analyze some data we have. Currently we are
showing the client then the product and then the sum of the Number of orders
and the percentage of margin. The table looks like this:

Client A Product1 Sum of ordernumber
Sum of MarginPercent
Product2 Sum of ordernumber
Sum of MarginPercent

Is is possible to have the data shown as:
Client A Product1 Sum of ordernumber Sumof MarginPercent
Product2 Sum of ordernumber Sumof MarginPercent

 

[Debra Dalgleish]

In the pivot table, drag the Data button onto the cell that contains the
word Total.

There's a picture here:

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

 

[Jim Moberg]

Thanks Debra. This worked great!

In the pivot table, drag the Data button onto the cell that contains the
word Total.

There's a picture here:

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