Hi All,
i have a requirement where i need to merge measures in two different columns in a single column with their column names in the corresponding rows.
below is the example for my requirement.
Orignal
Total Weight of Quotes Total Wt Won
237,945 121,514
1,456,101.5 45,743.5
286,997 22,443
302,401 64,639
604,375.38 145,995
277,470 12,014
Requirement
Total Weight of Quotes 237945
Total Weight of Quotes 1456101.5
Total Weight of Quotes 286997
Total Weight of Quotes 302401
Total Weight of Quotes 604375.38
Total Weight of Quotes 277470
Total Wt Won 121514
Total Wt Won 45743.5
Total Wt Won 22443
Total Wt Won 64639
Total Wt Won 145995
Total Wt Won 12014
Can we do this in report studio Query ?
Request you to guide me on this. thanks in advance.
Regards
You can create two queries. One for Total Weight of Quotes and one for Total Wt Won. You will need to add another column say, "Measure Type" which will contain two values say "Quotes" and "Won". Then union the two queries.
For example:
Q1:
Dim1 Dim2 Measure Type Measure
X Y Quotes 237945
union
Q2
Dim1 Dim2 Measure Type Measure
X Y Won 121514