Additional Excel
DeTazz
exc4_-_pivot_table_data_-_copy.zipEXC_4_Pivot_Table_Data.xlsx
Pivot_Data
| Sample Daily Sales at WildOutfitters.com | |||||||
| DATA ORGANIZED PROPERLY for Pivot Table Wizard | |||||||
| Sale Date | Sales Associate | Item Code | Item Type | Retail Price | Units Sold | Our Cost | Gross profit |
| 8/1/06 | MPG | BP | Backpack | $ 165.00 | 2 | $ 80.00 | $170.00 |
| 8/1/06 | MPG | HB | Hiking Boots | $ 110.00 | 4 | $ 50.00 | $240.00 |
| 8/1/06 | MPG | SB | Sleeping Bag | $ 100.00 | 2 | $ 45.00 | $110.00 |
| 8/1/06 | KLL | TT | Tent | $ 385.00 | 1 | $ 100.00 | $285.00 |
| 8/2/06 | MPG | BP | Backpack | $ 165.00 | 4 | $ 80.00 | $340.00 |
| 8/2/06 | HMW | HB | Hiking Boots | $ 110.00 | 6 | $ 50.00 | $360.00 |
| 8/2/06 | HMW | SB | Sleeping Bag | $ 100.00 | 3 | $ 45.00 | $165.00 |
| 8/2/06 | KLL | TT | Tent | $ 385.00 | 2 | $ 100.00 | $570.00 |
| 8/3/06 | PCA | BP | Backpack | $ 165.00 | 0 | $ 80.00 | $0.00 |
| 8/3/06 | KLL | HB | Hiking Boots | $ 110.00 | 3 | $ 50.00 | $180.00 |
| 8/3/06 | PCA | SB | Sleeping Bag | $ 100.00 | 1 | $ 45.00 | $55.00 |
| 8/3/06 | KLL | TT | Tent | $ 385.00 | 1 | $ 100.00 | $285.00 |
| 8/4/06 | MPG | BP | Backpack | $ 165.00 | 0 | $ 80.00 | $0.00 |
| 8/4/06 | HMW | HB | Hiking Boots | $ 110.00 | 1 | $ 50.00 | $60.00 |
| 8/4/06 | PCA | SB | Sleeping Bag | $ 100.00 | 0 | $ 45.00 | $0.00 |
| 8/4/06 | MPG | TT | Tent | $ 385.00 | 0 | $ 100.00 | $0.00 |
| 8/5/06 | MPG | BP | Backpack | $ 165.00 | 1 | $ 80.00 | $85.00 |
| 8/5/06 | HMW | HB | Hiking Boots | $ 110.00 | 1 | $ 50.00 | $60.00 |
| 8/5/06 | KLL | SB | Sleeping Bag | $ 100.00 | 0 | $ 45.00 | $0.00 |
| 8/5/06 | KLL | TT | Tent | $ 385.00 | 0 | $ 100.00 | $0.00 |
| 8/6/06 | MPG | BP | Backpack | $ 165.00 | 2 | $ 80.00 | $170.00 |
| 8/6/06 | HMW | HB | Hiking Boots | $ 110.00 | 6 | $ 50.00 | $360.00 |
| 8/6/06 | PCA | SB | Sleeping Bag | $ 100.00 | 2 | $ 45.00 | $110.00 |
| 8/6/06 | KLL | TT | Tent | $ 385.00 | 1 | $ 100.00 | $285.00 |
| 8/7/06 | KLL | BP | Backpack | $ 165.00 | 3 | $ 80.00 | $255.00 |
| 8/7/06 | HMW | HB | Hiking Boots | $ 110.00 | 2 | $ 50.00 | $120.00 |
| 8/7/06 | PCA | SB | Sleeping Bag | $ 100.00 | 5 | $ 45.00 | $275.00 |
| 8/7/06 | HMW | TT | Tent | $ 385.00 | 3 | $ 100.00 | $855.00 |
