Pivot Tables - Putting Additonal Data items beside each other.

Giganews Newsgroups
Subject: Pivot Tables - Putting Additonal Data items beside each other.
Posted by:  Jim Moberg
Date: Wed, 31 Jan 2007

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

Replies