Straight tables: dynamic Horizontal/Vertical

[#1]

Hi All,

I would permit to the user to rotate some tables (straight tables).

I mean the user may decide to see the figures

	Departments
Locations

Or

	Locations
Departments

We I design the object there is a flag Properties / Presentations / Horizontal, but the user cannot change it.

How can I solve it?

May I create a button with a macro?

But, in this case, could you please send me an example of code?

Any other idea is welcome

Thanks a lot

Ciao

[Clever_Anjos]

An approach is having 2 objects, one rotated other normal.

Use a button setting a variable to 0 or 1.

Set each graph Layout/Show condition to varible = 0 or variable =1

[#3]

Thanks Clever,

And using only one table? I would avoid to duplicate and so maintain 2 tables

[bbi_mba_76]

Hi,

I think you could use calculated dimensions with the flag:

if the flag=1 then the first dimension will be the Locations, else the Departments

the opposite for the second dimension

[Gysbert_Wassenaar]

See attached example

[Clever_Anjos]

gwassenaargave the solution using only one pivot table .

If you can use a pivot table this solution fits.