Rotated table or Matrix?
I have a dataset that has the following columns:
FirstOfMonth
TotalScore
AnotherScore
YetAnotherScore
In my report, I would like to put the dates as the column headers, and have each row show a different one of the scores across each of the dates, so the report would look something like the table below. I tried using a Matrix on the report, but I can't seem
to get more than one row into the report. I added the Matrix by dragging one on to the report, and then I dragged "FirstOfMonth" into the header of the first column in the Matrix. I then dragged TotalScore into the data field. Once I did that, I could not
figure out how to add additional rows to the report. Any ideas? Perhaps a tutorial? Am I using the wrong report item?
Jan 01
Feb 01
Mar 01
TotalScore
.1
.2
.3
AnotherScore
.4
.5
.6
YetAnotherScore
.3
.2
.1
November 30th, 2010 10:39am
http://msdn.microsoft.com/en-us/library/cc627571.aspxMy Blog "Karl Beran's BI Mumble"
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 12:33pm
http://blogs.msdn.com/b/robertbruckner/archive/2009/03/05/tablix-the-matrix-revolution.aspxMy Blog "Karl Beran's BI Mumble"
November 30th, 2010 12:33pm
Should be possible using the Matrix. I think you'll have to add RowGroups and then drag and drop the other measures to Rows. More information on adding Row Groups to Matrix is here -
http://msdn.microsoft.com/en-us/library/cc627571.aspx
A workaround is - changing your dataset to get the data in the format that you need. You'll have to use the PIVOT function for that. More information on pivot here -
http://msdn.microsoft.com/en-us/library/ms177410.aspx
Hope that helps.
Cheers,
ShalinShalin Kapadia
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2010 12:36pm