Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks Clever,
And using only one table? I would avoid to duplicate and so maintain 2 tables
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
See attached example
gwassenaargave the solution using only one pivot table .
If you can use a pivot table this solution fits.