+ Reply to Thread
Results 1 to 3 of 3

Skus and order sale lines total quantity within pivot table

  1. #1
    Registered User
    Join Date
    08-17-2021
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    11

    Skus and order sale lines total quantity within pivot table

    Good morning Forum Team
    I'm back again needing assistance with assistance with pivots for warehouse inventory. In my sample excel sheet, the customer stores, SKUs and quantities ordered are listed. How can I get excel to search for the SKU and the quantity ordered from all stores and display the grand total in a pivot table. Any suggestions? Which is the best method to go about this? Thank you!
    Kind Regards,
    Kingsley
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,069

    Re: Skus and order sale lines total quantity within pivot table

    First, I would recommend to put the data up in a an Excel table: Ctrl+T.

    Next, create the PivotTable by pulling "Sales Order/Order Lines/Product ID" to Filters section, "Sales Order/Order Lines/Customer" to Rows section, and finally Sales Order/Order Lines/Quantity to Values section.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-17-2021
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    11

    Re: Skus and order sale lines total quantity within pivot table

    Good Morning Josephteh,
    Thank you, it's just what I need. Thank you for your time. I have another question but I'll ask on my next thread.
    Kind Regards,
    Kingsley

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] skus in columm a for each sale, qty. of skus sold, each sale in co
    By JMB in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  2. [SOLVED] skus in columm a for each sale, qty. of skus sold, each sale in co
    By confused1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  3. [SOLVED] skus in columm a for each sale, qty. of skus sold, each sale in co-Need to sort
    By confused1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  4. [SOLVED] skus in columm a for each sale, qty. of skus sold, each sale in co
    By confused1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-11-2005, 05:05 PM

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