Question: Hello! I need help with pivotTables in Excel.. The inventory manager wants to know how much of each SKU to order for each month next
Hello! I need help with pivotTables in Excel..
- The inventory manager wants to know how much of each SKU to order for each month next year
- The market manager wants to know if they should renew the market agreements with each of the markets that they have
- The marketing group wants to know where they should place television advertisements next year
- The operations person wants to be able to see how many employees each arm of the business might need for the following year.
- The CEO wants an overall view of the business using sweet-looking visuals.
| IMEI | Date - Shipped Date | Bill To - Name | State | Item - Price | Item - Qty | Amount - Order Shipping | Amount - Order Tax | Amount - Order Total | Market - Store Name | Item - SKU |
| 4/9/18 19:25 | Person 1 | CA | $ 260.90 | 1 | $ - | $ - | $ 260.90 | Tiger Wireless | ||
| 4/6/18 16:23 | Person 18 | CT | $ 89.55 | 1 | $ - | $ - | $ 89.55 | Tiger Wireless | sku-auc-0 | |
| 4/6/18 16:21 | Person 19 | PA | $ 158.00 | 1 | $ - | $ 6.32 | $ 164.32 | Tiger Wireless | ||
| 4/6/18 16:21 | Person 20 | AL | $ 160.15 | 1 | $ - | $ - | $ 160.15 | Tiger Wireless | sku-auc-3 | |
| 4/6/18 16:21 | Person 21 | AK | $ 160.00 | 1 | $ - | $ - | $ 160.00 | Tiger Wireless | ||
| 4/6/18 16:21 | Person 22 | HI | $ 134.99 | 1 | $ - | $ - | $ 134.99 | Tiger Wireless | sku-auc-3 | |
| 4/6/18 16:21 | Person 23 | CA | $ 184.45 | 1 | $ - | $ - | $ 184.45 | Tiger Wireless | sku-auc-1 | |
| 4/6/18 16:21 | Person 24 | CT | $ 159.99 | 1 | $ - | $ - | $ 159.99 | Tiger Wireless | ||
| 4/6/18 16:21 | Person 25 | PA | $ 189.00 | 1 | $ - | $ - | $ 189.00 | Tiger Wireless | ||
| 4/6/18 16:21 | Person 26 | AL | $ 90.00 | 1 | $ - | $ - | $ 90.00 | Tiger Wireless | sku-auc-1 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
