Dimensions in one column

[Anonymous]

Hi,

Question about dimensions in a straight table / pivot table.
I would like to have three dimensions in one column. For three different dimensions I would like to see the same expression (sum of sales).
At this moment I have exactly what I need, but I don't like the layout of the table.
In column 1, line 1, I see the first dimension. In column 2, line 2, I see the second dimension, etc.
I would like to see all the dimensions in the first column. Is this possible?

Thanks in advance for your help!

Henco

[#2]

clicking 'Indent mode' in the style tab can approximate what you need

[Anonymous]

Thanks for your reply.
It works exactly as I wish to, but it should be nice if I could give the different dimensions a label.
I think that's not possible with this option? So, I would like to see al the labels of the dimension in the first column.

[#4]

Can you not have multiple dimensions in the first column based on some conditions? like;

if (condition 1, dimeinsion1, if (condition2, dimension2, dimension 3))

This way you can have all in one column.

[#5]

Does somebody know if it's possible to have the values of different dimensions in one column?

I need to have each value of five dimensions each in a new row.

Preferably in a pivot table

[Anonymous]

Hi,

Properties-->style tab---> indent mode (check)

Hope this may help.

[#7]

Thank you, Nisha, for your reply, only thing is that this only changes the view of my pivot.

What I realy need is to have each separate value in it's own row/cell.

Perhaps you, or someone else, can provide me with a statement that arranges these separate dimensions in one column, without the indent mode.