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 |
|---|
