Another Pivot Table Question

C

cirelli

Thank you for helping me on my last post. Now a new
question...

ColA ColB ColC

AMGN BOX969 1773
BOX919 515
BOX549 1092
BOX980 901
BOX792 614
BOX418 406
AMZN BOX549 3307
BOX980 1113
BOX792 2819
BOX418 209
BOX947 730
AZN BOX549 405
BOX792 86
BOX904 625
BOX551 210
BOX060 322

ColA has my Customers, ColB has Products, and ColC the
total of the product purchased.

Is there an easy way to have each customer's product
purchased sorted in decending order (i.e. the prduct that
they purchased th most of at the top) ?

Thanks in advance.
 
F

Frank Kabel

Hi
try the following
- create your pivot table
- select the product field
- in the pivot menu choose 'Sort and Top 10' (hope this is the right
translation'
- choose your sorting format
 
Top