As we have seen, the Merge option enables us to connect between several datasets, but what are the rules applied to the merge behavior?
The Merge option basically creates a union between the data providers. As we have seen, the effect is a full union that shows the common values in a single row.
Let's reverse the procedure and examine what the effect is without a merge and what other type of merge operators we can apply.
We have two tables that we require to merge in the report.
Let's have a look first at both of the tables' data.
We have a table with unique and common values, and both already have a global sum in each tables' footer.
Let's drag an unmerged dimension this time and see what the ...