Skip to Content

Analysis: Is it possible to retrieve the number of rows in a crosstab before it is displayed?


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.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers