Re: Pivot Tables - Putting Additonal Data items beside each other.

Giganews Newsgroups
Subject: Re: Pivot Tables - Putting Additonal Data items beside each other.
Posted by:  Debra Dalgleish (d…@contexturesXSPAM.com)
Date: Wed, 31 Jan 2007

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 wrote:
> 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
Contextures
http://www.contextures.com/tiptech.html

Replies

In response to

Pivot Tables - Putting Additonal Data items beside each other. posted by Jim Moberg on Wed, 31 Jan 2007