Hi,
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
https://archive.sap.com/discussions/thread/3497125
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.
Hello - are you using Analysis Office 2.4? You can use the Group Crosstab feature or link dimension feature mentioned here: https://blogs.sap.com/2016/11/28/reviewing-what-is-new-in-businessobjectanalysis-office-2.4/
They place side by side without overlap
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.