Dinamicaly position pivot table one under the other
Hy guys. I have a question. I have two pivot table which they are positioned one under the other. Both of them ar seted in layout to resize after containing data. I would like to change the second table`s position depending on the dimmension of the first table.
Not really. This could be done only with macros which aren't recommended within the gui. If there only a few possible positions you could create several pivots with different positions and which have a visibility-condition to the number of possible dimension-values from the first pivot. Otherwise you will need to live with scrollbars or to find a different usability to show them - maybe within a container.