After creating a query using query builder, the query is a union of two queries. it returns a result set with no problem.
However, when one try to use the Pivot and Chart Tab, the Pivot Grid Field list is not reflecting the current output of the query.
Also, in the query, each column has an alias that matches with a column of the second query after the UNION statement.
The order in the columns is not the same in each query.