Need help with Chart

[scott_simmons]

We use a configurable product and I would like to do analysis on how often a configuration is used.  I am pasting the Grid of Data that came from a quick chart but as you will see the qty and sales are repeated due to the various configuration parameters and I would like to be able to aggregate the metrics(sales, quantity) for how it is configured.  Please Help.

%OrderLine ConfigLabel ConfigValue Qty Sales Avg	11340 $5386.50 0.4750	703/128963-01/611340$5386.500.4750	703/128963-01/6# of Rolls3511340$5386.500.4750	703/128963-01/6BAG11340$5386.500.4750	703/128963-01/6DBL FACED(Y/N)?N11340$5386.500.4750	703/128963-01/6FACINGP1011340$5386.500.4750	703/128963-01/6FACING WIDTH7811340$5386.500.4750	703/128963-01/6GLASS WIDTH611340$5386.500.4750	703/128963-01/6Internal Comments11340$5386.500.4750	703/128963-01/6LENGTH5411340$5386.500.4750	703/128963-01/6PLACEMENTR11340$5386.500.4750	703/128963-01/6Printable CommentsBldg. B - Roof - Over Peak11340$5386.500.4750	703/128963-01/6R-VALUE1911340$5386.500.4750	703/128963-01/6TABS611340$5386.500.4750	703/128963-01/6TAPE TABN11340$5386.500.4750

[scott_simmons]

Sorry, the grid looked better before I hit post.