Results 1 to 4 of 4

Pivot table for made and sent dates

Threaded View

  1. #1
    Registered User
    Join Date
    07-27-2007
    Posts
    5

    Pivot table for made and sent dates

    Hey guys,

    I've been tackling this issue for a while. Basically my data source is some inventory data, which has two dates (in year) for when the product was made, which factory it was made in, and when it was sent out. So a typical entry would look like this:

    ID#       Factory          DateMade         DateSent
    415612  New York        2001                2004
    I have a pivot table that illustrates the data from this data, and I want it to have the year, the count for the number of products made, and then the count for the products sent broken down by year and factory. So, something like this:

    Year      Factory          Count of Made   Count of Sent
    2001                          1923                1709
                New York        1521                1203
                New Jersey     402                  506
    
    2002                          2201                2202
                New York        1699                1802
                New Jersey      502                 400
    The problem is, I've set most of the table based on the "Year" being the year made, so when I try to do the Count o sent, I can only look up what was made in the year. Anyone have a good idea for this? Thanks in advance.
    Last edited by gozillasnack; 08-17-2007 at 01:59 PM.

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