Pivot Tables - Putting Additonal Data items beside each other.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Moberg - 31 Jan 2007 14:32 GMT

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

Reply to this Message

Debra Dalgleish - 31 Jan 2007 14:43 GMT

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

> 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
[quoted text clipped - 8 lines]
> Client A Product1 Sum of ordernumber Sumof MarginPercent
> Product2 Sum of ordernumber Sumof MarginPercent

Signature

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

Reply to this Message

Jim Moberg - 31 Jan 2007 15:00 GMT

Thanks Debra. This worked great!

> In the pivot table, drag the Data button onto the cell that contains the
> word Total.
[quoted text clipped - 15 lines]
> > Client A Product1 Sum of ordernumber Sumof MarginPercent
> > Product2 Sum of ordernumber Sumof MarginPercent

Reply to this Message