Can you sort rows through multiple grids in a management report oracle cloud?

Hello,

I created a report that is set to bottom levels of all hierarchies within the cube. This causes query limits errors when there is a large number of blocks. The report has been optimized by turning on suppression for no data and missing blocks as well as using the ASO cube for faster run times. To mitigate the query limit issue, I decided to break down the queries into three grids. As a consequence, the sorting created in the "one Grid" report goes out the window. Is there a way to sort the report across the three grids?

There is also another issue that comes from gaps in between the grids, is there a ways to make all three grid display seamlessly?