I need to setup a pivot table to see the Item-Name and how many times the Item was ordered.
The source:
Column A - Date-Of-Order
Column B - Item-Name
Column C - Item-Number
Each time a customer orders the item, the table makes several rows, one per each item. Therefore, you will have 3 rows if customer orders 3 one-inch nails (Item Number) - Item-Name is Nails. Each row will repeat one item-number (same in 3 rows) and Item-Name (same in 3 rows). The date-Of-Order will also repeat.
Is customer order today 3 one-inch nails and next week and order of 5 one-inch nails, then I want to see the counter showing 2 (NOT 8), since here were 2 separate orders. The break will be the date. Different Date-Of-Order is the counter.
The table should look like this and show how many times the item was ordered (and not the number of the items ordered):
Nails
1-inch ordered 2 times
2-inch ordered 1 times
3-inch ordered 1 times
4-inch ordered 3 times
Screws
1-inch ordered 3 times
1.2-inch ordered 1 times
1.5-inch ordered 2 times
Bookmarks