Position of Totals in BAO
I am experiencing some slightly annoying positioning of Results rows. When I connect to a BEx query, some of the totals are appearing at the bottom (as I have specified in the BEx query), but one is appearing at the top. I am attaching a pic to show what I mean. I have circled the one which appears at the top of a range in red, the rest I am happy with and are in green. Ignore the tipex!
Anyone else experienced this and is there a workaround you can share?
One of my colleagues has found a solution to this - changing the Hierarchy Settings to Expand Upwards (Rows) moves the total to the bottom.