Matrix Tool

  • I am trying to get the result from one data set in a pivot style....

    Input

    Salesid, CustId,region ,7-2013 6-2013....................(Past12 months)

    1 1 NY 500 200

    1 1 TX 200 400

    1 2 NY 300 300

    2 2 TX 400 200

    Output Expected

    When I pass values SalesId = 1 , CustiD = 1

    It should show me

    Salesid, CustId,region ,7-2013 6-2013....................(Past12 months)

    1 1 NY 500 200

    1 1 TX 200 400

    But its just showing me the 1st rec

    Salesid, CustId,region ,7-2013 6-2013....................(Past12 months)

    1 1 NY 500 200

    The result shows up fine when I use Table, But doesn't with Matrix.

    Kindly advise?

  • Need more information. Can you post the query? It sounds like you aren't getting the results you are expecting back from the query.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply