Dynamic dimension on pivot table

[menta]

Hi all,

I try a solution to create a dynamic dimension into a pivot table. This dimension nedd to change based on selections.

In my orginal pivot table I have a master dimension in row and a subdimension on column.

This generate a big table, with few value on each row, like a snake.

My desire is to have a table with column = max number of subdim in master and use into expression a dual value with subdmin name and is value

For example, if I select Year 2013,-->12 columns

How can i have this kind of value for each cells:

I try to have a result that i can compare with a valueloop in dimension

Is it possible? Can anyone help me?

Thank you