+ Reply to Thread
Results 1 to 6 of 6

Multiple rows make a single order and Pivot table

  1. #1
    Registered User
    Join Date
    11-08-2007
    Posts
    21

    Multiple rows make a single order and Pivot table

    Please help- Multiple rows make a single order and Pivot table

    Hi all,
    Enclosed is the sample file.

    I hope some one can help me with this. I have a spreadsheet with order ID title and several rows collectively constitute one order (worksheet- Order received). I also have data that shows the order has been made using what mode - email, online etc (worksheet- order source). Can somebody tell me how do I make a pivot table using these two worksheet that shows which order has been made using email, online etc.

    I did try to make. Since multiple rows make one order, I always get more number of order than actual.

    For instance, order ID 237160, has seven items and this counts as seven online order instead of one. What I tried to do- was to insert another column using vlookup from 'Order source' worksheet to make a pivot table and I get inflated counts.

    I hope some experienced member could help me please.

    Why the forum is not allowing me to upload the file.
    Attached Files Attached Files
    Last edited by saurya_s; 10-30-2008 at 02:02 PM.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Hi Saurya
    you file might be too large or of an unknown type
    100K is the max I think

  3. #3
    Registered User
    Join Date
    11-08-2007
    Posts
    21
    Is there any other way I can do. Even by compressing I can not amke it smaller than 200kb.

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    We don't need ALL the data. Just extract a sample

  5. #5
    Registered User
    Join Date
    11-08-2007
    Posts
    21
    OK posted the sample. Many thanks mate.
    S

  6. #6
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Errrr , no file..

+ 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