Results 1 to 7 of 7

Basic Pivot Table Help

Threaded View

  1. 10-16-2014, 09:49 AM #1
    Karen615
    Karen615 is offline
    Registered User
    Join Date
    10-30-2012
    Location
    Chicago
    MS-Off Ver
    Excel 365
    Posts
    93

    Basic Pivot Table Help

    See attached for data file

    I need a pivot table to show me (for example in Div1)
    For product ID 12345, widget 1, there were 6 cancellations on 10/3 and product ID 12345, widget 1 there were 7 cancellations on 10/5
    For product ID 54321, widget 2, there were 4 cancellations on 10/7
    Etc. Then I need a grand total of the number of units per division.

    I hope I'm explaining this clearly.
    Any help would be greatly appreciated.
    Thank you in advance, Karen
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. help creating basic pivot table...
    By yertleturtle in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-18-2014, 12:22 PM
  2. Basic Pivot Table Questions
    By shadestreet in forum Excel General
    Replies: 0
    Last Post: 04-17-2006, 11:58 AM
  3. Basic Pivot Table Questions
    By shadestreet in forum Excel General
    Replies: 1
    Last Post: 04-14-2006, 07:25 PM
  4. Basic Pivot Table Question (using 97)
    By Adam Kroger in forum Excel General
    Replies: 3
    Last Post: 11-25-2005, 07:40 PM
  5. [SOLVED] Basic: Pivot Table formats
    By Bettergains in forum Excel General
    Replies: 3
    Last Post: 09-22-2005, 09: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1