September 19, 2013 at 9:46 am
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?
September 19, 2013 at 12:03 pm
Need more information. Can you post the query? It sounds like you aren't getting the results you are expecting back from the query.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply