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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics