show table with dimensions and dimension values horizontally

[felcar2013]

hi

i want to show dimensions and their values horizontally. One dimension has vertical values

On the left side, there are two dimensions: Age  Group and Gender. The dimensions values shall be shown horizontally and the dimensions shall appear one after the other. Is this possible?

QUARTER		2013 Q1	2013 Q2	2013 Q3	2013 Q4
AGE GROUP	18-25	23	54	26
	26-35	54	66	45
	36-45	12
	46-55
	56-65
	65+
GENDER	Male
	Female
	Not specified

[rbecher]

Hi Felipe,

just use a pivot table and pull the Gender dimension to the upper right heading part.

- Ralf

[felcar2013]

thanks, but we need to have even not only two dimensions horizontally, the vertical (heading) one is the time. Gender must be on the left side

[rbecher]

Could you please upload an example QVW with sample data and the required layout as an Excel file od screenshot..

[felcar2013]

thanks, but i really do not think it is possible to present "n" dimensions and their corresponding values horizontally in one table. I presented for this example 3 dimensions: quarter, age group and gender with its values, but the dimension number can be much greater. I have no sample data which is logical now and i cannot post real data

felipe