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?