Hi

You can almost do what you want.
Provided you can accept

Customer Item 1 Item2 %Item1 %Item 2 Total
CustA 6 4 60% 40% 10
CustB 50 50 50% 50% 100

Drag Customer to Row Area, drag Item to Column Area.
Drag Quatity to data area twice.
Double click on the second quantity field in Layout dialogue, and choose
OptionsShow data as select % of Row from dropdown.

--
Regards

Roger Govier


wrote in message
ups.com...
I wanted to create a pivot table like the result below.

The important thing is that I have percentages at the end of each
column and
the totals end up at the end.


Item 1 Item 2 Total Items sold

Customer A 6 Sold 60% 4 Sold 40% 10 Sold


Customer B 50 Sold 50% 50 Sold 50% 100 Sold


How can I do the above?