Transforming / spread the values of a table from year to month

[dennisthemenace]

Good morning everybody,

as given in the title , I have a table like:

Dimension 1    Dimensions 2     value (per year)

          xxx                        yyy                           120

I would now like to transform it to something like:

Dimension 1    Dimensions 2     value (per month)

          xxx                        yyy                           10

          xxx                        yyy                           10

           ...

At the end of the day, it should be possible to concatenate with a before loaded crosstable where the values (Jan,Feb..) are given per month:

CrossTable(Month, value, 3)

LOAD

Dimension 1,

Dimension 2,

Jan as 01,

Feb as 02,

...

;

Any Suggestion how to get it the right way?

Regards,

[dennisthemenace]

I recently found a way:

1) For my standard table I defined the value row as revenue/12 as value

2) left join inline load :

month,

01,

02,

...

Now, I get the table as I want. But unfortunately I dont get it concatenated with the cross table

with the statement Concatenate("CrossTableName")