Hi,
I have a beginner question.
I am union'ing 2 queries in report studio. Each of the query is rolling up data based on detail aggregation property as 'Total' (As an example for a row, the measure column "Meas" adds three rows' values 10+5+15 from 3 rows and give as 30).
Now After the union, unless I make the detail aggregation in the union'ed query also as "Total", it splits the row again into three separate rows with Meas values as 10,5 and 15. Is there any option to avoid this behavior OR It always need this change?
Thanks,
That's what I'd expect it to do - the union query has it's own aggregation rules so you'd need to specify total there. The child / sub queries won't effect the aggregation in the union