[Urgent] How to create a straight table in the following fashion

[#1]

How to create the straight table in the following fashion(It looks like cross table.)

Last 5 Quarters

EV/Person

Rolling 12 Mths

FY 2012

FY12Q3

FY12Q4

FY13Q1

FY13Q2

FY13Q3

Aug-13

Sep-13

Oct-13

Nov-13

Dimension1

Dimension2

Dimension3

In genearl when you create a straight table, the mentioned dimensions and columns would be added side by side, but in my requirement dimensions should be added as rows and expressions should be populated as columns.

[tresesco]

Use pivot table and pull the month field across column. Else, in straight table , you have to write individual expressions for each months.

[#3]

In The pirvot table as well dimensions and expressions would be populated side by side, in my requirement I should populate dimensions in the rows, expressions should be populated as columns.Alll the columns values would be calculated expressions.

[#4]

Create straight table with all dimensions required then drag and drop diamention to left side which shows your data.

thanks and regards

shiv

[tresesco]

May be like attached sample?

[#6]

Yes Tresco, exactly the same way