How to create a table? newbie question

Question

User-1251172648 posted

Hi,

Could someone help me figure out how to create this sort of table? I tried using Matrix and Table option but can't find a way to do it.

So for specific account, I want to have my Year under Columns, so 2008, 2009, etc

and I want my Revenue, Expenses, Marketing under rows.

Something like:

Account #1
	2008	2009	2010	2011	2012
Revenue
Expenses
Marketing

Answer 1

User364480375 posted

refer this:

http://www.w3schools.com/sql/sql_create_table.asp

Answer 2

User1975998971 posted

If this is for SSRS, you do use the table element but you will have to set a dataset in the Tablix properties.  From there you can fill in the table with what you need for years which will be a column grouping for the years and you can either hard code the three types under the rows and just sum up what you want in the middle.