Pivot Table Results

  • Thread starter Thread starter crelli
  • Start date Start date
C

crelli

Hi. I have a pivot table that lists my customers in the
rows and products in the columns. The body of the table
records the sum of the respected product purchased.

I have 100 customers and 200 products.

I there an easy way to list for each customer the
pruducts they have purchased and the amount purchased ?

Thank you in advance.
 
Hi

One way (but i would do it on a smaller number of customer's first to see if
its what you want)

pull the customer's field up into the Page section
Put the products in the column

then from the Pivot Table toolbar
choose Pivot Table
Show pages
click on customers and click OK

this will put each of the customer's on a separate page (ie you'll end up
with 100+ pages) with the products & quantity

Hope this helps

Cheers
JulieD
 
Hi
if your source data is organized in the following way:
A B C
customer product amount
... ... ...

Use the customer and product as row and sum of amount as data in your
pivot table
 
Back
Top