Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2013

    Unanswered: New to Cross Tabs

    I am new to Cross Tabs and am wondering if this is even possible.
    I have an attachment that is what the report is now.
    Just in case this is what I currently have
    Job # Material Description Grp Date Spoiled
    60456 2478 Polyethylene PPE 11/7/13 1000
    60456 2478 Polyethylene PPE 11/7/13 600
    60456 2248 Polyester PE 11/7/13 2000

    What is being requested is to make a new column for each Material

    So it would be like this

    Job # Material Description Date PPE Spoiled PE Spoiled
    60456 2478 Polyethylene 11/7/13 1000
    60456 2478 Polyethylene 11/7/13 600
    60456 2248 Polyester 11/7/13 2000

    There are a lot of possible Grp (Group) and I want it to dynamically add
    or remove columns based on how many groups there are. Hoping
    a Cross Tab could do it.
    If so how? I have not been able to show the grps and other information on
    one row. Any tutorials would be helpful.

    The ones I have found have not explained how to have
    Job #, Material, Description, date on the same
    row with Spoiled and still show all records and all possible GRPs.

    I know I can hard code this by making 13 columns, 1 for each possible
    GRP but that does not allow for adding and deleting a GRP.

    Thanks Andy
    Attached Thumbnails Attached Thumbnails aaa.jpg  

Posting Permissions

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