Crosstab and multiple sets of dimensions in the row area.

I am trying to create a crosstab where I have multiple sets of dimensions in the row area. But a common Dimension in the Column Area. Can this be done some how?

| YEAR (Column area)

LevelA, LevelB, LevelC | DetailA, DetailB
LevelX, LevelY | DetailK, DetailJ, DetailI

Note: Set page break on year, render as:

| 2006

LevelA, LevelB, LevelC | ValueA, ValueB
LevelX, LevelY, | ValueK, ValueJ, ValueI

| 2007

LevelA, LevelB, LevelC | ValueA, ValueB
LevelX, LevelY, | ValueK, ValueJ, ValueI

| 2008

LevelA, LevelB, LevelC | ValueA, ValueB
LevelX, LevelY, | ValueK, ValueJ, ValueI

| 2009

LevelA, LevelB, LevelC | ValueA, ValueB
LevelX, LevelY, | ValueK, ValueJ, ValueI

Find more posts tagged with

Comments

mwilliams

Hi buckethead,

So, year is the only column dimension? What are the multiple row dimensions? The level A, B, and C? Can you explain further what you're actually wanting to get?

jashaffner

I can give you an example here as I am trying to do something similiar.

I would like to create a crosstab with Time dimension for the column area and company and region dimensions for the row area. The measure could be sales amount.

Jan Feb Mar
company 100.00 102.00 101.00
region 456.00 503.00 487.00