Skip to Content

Placing two queries without overlap - Ananlysis for office

Apr 06, 2017 at 06:29 AM


avatar image


I am loading two queries starting at A6 and A200 in AO.

My first query has more than 200 records and when the data is loaded, i am ending up with this crosstab overlap issue.

I came across this post and trying to implement this

Question is, will I be able to influence query two starting location?

if query one has 300 records, can we able to place the query two at A306 with the above post? Can we influence the location of query two starting position (depending on number of records) or query two will be placed at A5000 OR A10000 and then we have to hide all the empty rows?

Somehow, I am not able to get the desired results for placing query two at my desired location.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Tammy Powlas
Apr 07, 2017 at 08:58 AM

Hello - are you using Analysis Office 2.4? You can use the Group Crosstab feature or link dimension feature mentioned here:

They place side by side without overlap

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy,

Yes, I am using 2.4.

Thank you for this blog.

- Shahid


Hi Tammy,

I am able to place the crosstabs side by side.

Is there a way to place one below the other? May be some sort of a setting or by a VBA code?

or is it like the initial place of cross tabs is always fixed?


Hi - I only know the side-by-side option; I am not familiar with VBA - that might work.