Merge Measures in Two Columns Into Single Column

[Raghuvir]

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

[Francis aka khayman]

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