Skip to Content

Placing two queries without overlap - Ananlysis for office


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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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

    Add comment
    10|10000 characters needed characters exceeded