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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center