July 13, 2011 at 1:13 pm
Hi I have a matrix problem as follows, Hope Gurus can help. I need to have a data in one single row. Thanks for your time.
A, B, C are column level groups
D, E are row level groups
C1, C2, C3 columns give me data for the matrix (such as 3,4,5)
--------------------------------------------------
A
-----
B
-----
C
---- ---c1-c2-c3----
D-> E> 3 - -
>>>> - 4 -
>>>> - - 5
----------------------------------------------------
I want to make
3-4-5 in one line istead of 3 different rows since they have same grouping.
Thanks !!
July 13, 2011 at 1:32 pm
Can you create a sample data set (select with union alls) and post what you have in a rdl file? I'm not too sure I understand what you need nor how to build it out.
July 14, 2011 at 7:57 am
Thanks for your reply.
I was able to do it using Pivot function in my code.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply