Position of object dependant on size of other object

[#1]

Hi,

Is there a way to change the X / Y position of an object depending on the size of another object.

I have 2 pivot tables (which due to the width have to be underneath each other).

The first table has 2 conditional dimensions which are toggled by a button through a variable.

The 2 dimensions have differing distinct values, one has 4 values, one has 12.

When the dimension with 4 values is selected, I would like the table underneath to be close to the top table.

When the dimension with 12 values is selected, I would like the table underneath to move down on its Y pos so it is not obstructing the newly increased first table.

Hope this is clear!

Any help is appreciated.

Adam

[sushil353]

This might be possible using macros

[#3]

Thanks,

Can anyone help with the code? I don't have a version of the API guide installed.

I understand what I need:

     set y position of object 2 = y position of object 1 + y size of object 1 + 20

Thanks

Adam

[sushil353]

please find the api guide