dimension in pivot one below the other

[#1]

Hi I have a question,

is it possible to put the Dimension in a Pivot one below the ozher instead of side by side??

Thanx

[PrashantSangle]

NO...

[#3]

ok and with a lot of hours with new tables and so on???

[hariprasadqv]

Pivot allows reorganizing the position of the fields from horizontal to vertical and verticle to horizontal just by drag and dropping into Appropriate position.

[PrashantSangle]

Hi,

I am sorry but i did not understand your requirement.

Can you elaborate?

Regards

[#6]

i try

normal abroach

Dim1     Dim2     Dim3

              Dim2    Dim3

                          Dim3

in all Dimension are values and i have a sum

so my Task is to bring it dim one below another

my example

value

value

value

Dim1sum

value

value

value

value

Dim2sum

value

value

Dim3sum

[tresesco]

You might try with Indent mode (Style tab) of the chart and proper alignment. Check the attached sample.

[#8]

thanx for your answer but i dont want teh dim colums side by side only in one column...

[buzzy996]

I think so u can do it, drag dimension column as row in pivot table and see,tht's what ur expecting the result or not.

the data some thing like this,

Dim          proda                                    prodb

Dim2   proda1  proda2  exp1   prodb1   prodb2 exp1