+ Reply to Thread
Results 1 to 2 of 2

Pivot table displaying item name and how many item numbers were used

  1. #1
    Registered User
    Join Date
    05-17-2010
    Location
    New York, USA
    MS-Off Ver
    Excel 2010
    Posts
    39

    Pivot table displaying item name and how many item numbers were used

    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
    Last edited by vicstone; 12-03-2019 at 02:28 PM. Reason: Additional Info

  2. #2
    Registered User
    Join Date
    05-17-2010
    Location
    New York, USA
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Pivot table displaying item name and how many item numbers were used

    Test file uploaded
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1