Another function which we can use to define the dynamic row/column for Grid is Union. This one can be used if the you want to create one table based on more than one query. For example - let’s say we want to mix results for makes and segments together, having sorting applied on the aggregated list.
By default, SELECT QUERY will translate this into two separate dynamic rows, which can only be sorted separately.
One tab reference will retrieve a list of all segments and another one will get a list of all the makes.
Using Union will create one table that will have rows from both - such a newly created table can be further modified, for example, by sorting.
