| Description | Category Type | Category Name | SKU | Supplier | Manufacturer | Gross Store Price Qty | Gross Store Price Sold$ | Gross Store Price Avg$ | Returns Qty | Returns Sold$ | Returns Avg$ | Sales Discounts Qty | Sales Discounts Sold$ | Sales Discounts Avg$ | Return Discounts Qty | Return Discounts Sold$ | Return Discounts Avg$ | Net Sales Qty | Net Sales Sold$ | Net Sales Avg$ | Tax on Net Sales Qty | Tax on Net Sales Sold$ | Tax on Net Sales Avg$ | Inventory | Cost | Cost of Goods Sold | Name | Value |
| IPHONE 6S/7/8+ CASETIFY GLITTER TAKEABOW | Case | Fashion | 135859 | Cesium | Casetify | 1 | 49.95 | 49.95 | 0 | 0 | 0 | 1 | 44.95 | 44.95 | 0 | 0 | 0 | 1 | 5 | 5 | 1 | 0.55 | 0.55 | 2 | 20.6 | 20.6 | Device1 | IPHONE 6S+ |
| IPHONE 6S/7/8+ CASETIFY GLITTER TAKEABOW | Case | Fashion | 135859 | Cesium | Casetify | 1 | 49.95 | 49.95 | 0 | 0 | 0 | 1 | 44.95 | 44.95 | 0 | 0 | 0 | 1 | 5 | 5 | 1 | 0.55 | 0.55 | 2 | 20.6 | 20.6 | Device2 | IPHONE 7+ |
| IPHONE 6S/7/8+ CASETIFY GLITTER TAKEABOW | Case | Fashion | 135859 | Cesium | Casetify | 1 | 49.95 | 49.95 | 0 | 0 | 0 | 1 | 44.95 | 44.95 | 0 | 0 | 0 | 1 | 5 | 5 | 1 | 0.55 | 0.55 | 2 | 20.6 | 20.6 | Device3 | IPHONE 8+ |
I have this data that has been transposed on the devices, to give an attach rate between the accessory (here) and the device (in another data set). One problem is transposing these models into device 1, device 2, device 3 inflates thus tripling the quantities. Across my entire data set, how can I say if Name=!"Device 1" make Gross Price -> cost of goods sold NULL or zero (I am unsure). In doing so I hope to not inflate the quantities but keep being able to attach an iphone 8+ accessory to an iphone 8+ phone.
This could also not be possible given that a null will make that quantity 0 for an iphone 8+ and therefore no attach rate. Perhaps someone has a better idea on how I could do this without inflating everything.
Before I transpose for example, I have the columns device 1, device 2, device 3, so this duplication or triplication does not exist at that stage.
| Description | Category Type | Category Name | SKU | Supplier | Manufacturer | Gross Store Price Qty | Gross Store Price Sold$ | Gross Store Price Avg$ | Returns Qty | Returns Sold$ | Returns Avg$ | Sales Discounts Qty | Sales Discounts Sold$ | Sales Discounts Avg$ | Return Discounts Qty | Return Discounts Sold$ | Return Discounts Avg$ | Net Sales Qty | Net Sales Sold$ | Net Sales Avg$ | Tax on Net Sales Qty | Tax on Net Sales Sold$ | Tax on Net Sales Avg$ | Inventory | Cost | Cost of Goods Sold | Device1 | Device2 | Device3 |
| IPHONE 6S/7/8+ CASETIFY GLITTER TAKEABOW | Case | Fashion | 135859 | Cesium | Casetify | 1 | 49.95 | 49.95 | 0 | 0 | 0 | 1 | 44.95 | 44.95 | 0 | 0 | 0 | 1 | 5 | 5 | 1 | 0.55 | 0.55 | 2 | 20.6 | 20.6 | IPHONE 6S+ | IPHONE 7+ | IPHONE 8+ |
