Hello,
I'm trying to work around a situation where I have DataSource1 overlap DataSource2 if its drill-down is large enough. As a result not all rows in DS1 are displayed. I would like to use VBA to dynamically insert/delete rows every time the drill-down is changed in order to accommodate the data that will be displayed and avoid these overlaps. As a result, I need to know how many rows the crosstab will need in order to display all data in the selected drill-down without overlapping another crosstab. Is this possible? If yes, is there a callback that can be called before expanding/shrinking the layout after changing the drill-down?
Note: I cannot use DS1's range address as its end point is set as the last row before the overlap occurs.
Thanks