Pivot Tables Showing Related Information Once

[mwooten777]

Not sure how to word the topic here. I have a set of data that lists parts and customers and sales. A given part number belongs to only one customer. I want a pivot table that sums the sales of parts - easy. The hard part is I'd like the pivot table to also show the customer for that part, in a tabular format.

Here's what my sample data looks like:

[TABLE="width: 159"]
<tbody>[TR]
[TD]Part
[/TD]
[TD]Cust
[/TD]
[TD]Sales
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]ACME
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]234
[/TD]
[TD]SAP
[/TD]
[TD]38
[/TD]
[/TR]
[TR]
[TD]345
[/TD]
[TD]NCR
[/TD]
[TD]26
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]ACME
[/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD]234
[/TD]
[TD]SAP
[/TD]
[TD]42
[/TD]
[/TR]
[TR]
[TD]345
[/TD]
[TD]NCR
[/TD]
[TD]12
[/TD]
[/TR]
</tbody>[/TABLE]

When I drag the Cust field into the pivot table it looks like this:

[TABLE="width: 138"]
<tbody>[TR]
[TD]Row Labels
[/TD]
[TD]Sum of Sales
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]16
[/TD]
[/TR]
[TR]
[TD]ACME
[/TD]
[TD]16
[/TD]
[/TR]
[TR]
[TD]234
[/TD]
[TD]80
[/TD]
[/TR]
[TR]
[TD]SAP
[/TD]
[TD]80
[/TD]
[/TR]
[TR]
[TD]345
[/TD]
[TD]38
[/TD]
[/TR]
[TR]
[TD]NCR
[/TD]
[TD]38
[/TD]
[/TR]
[TR]
[TD]Grand Total
[/TD]
[TD]134
[/TD]
[/TR]
</tbody>[/TABLE]


Here's what I'd like my pivot table to look like:

[TABLE="width: 159"]
<tbody>[TR]
[TD]Part
[/TD]
[TD]Cust
[/TD]
[TD]Sales
[/TD]
[/TR]
[TR]
[TD]234
[/TD]
[TD]SAP
[/TD]
[TD]80
[/TD]
[/TR]
[TR]
[TD]345
[/TD]
[TD]NCR
[/TD]
[TD]38
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]ACME
[/TD]
[TD]16
[/TD]
[/TR]
</tbody>[/TABLE]

How can I make this happen?

Thanks,
Mark

 

[bkaehny]

1. Click anywhere inside the pivot table.
2. Click on the "DESIGN" tab underneath the "PIVOTTABLE TOOLS" ribbon.
3. Click on the "Report Layout" button.
4. Click on "Show in tabular form."

 

[mwooten777]

SORRY - I figured it out. Thanks.