Joins and Unions across accounts and using data from multiple accounts.
In addition to Joins and Unions in the same company, it is possible to do the same exercise across accounts.
This means, among other things, that a customer can compare several companies' finances in the same Pivottable.
NOTE: Unions only displays data if the two tables' fields have the same names.
Here is an example of two accounts appearing in the same PivotTable and calculating a difference between companies.
A "Union All" is built between two accounts.
The same Table is "Added" from two accounts.
Here "GLTransSumClient" is added from Company 1 and Company 2.
After Union All Laves three calculated fields
First, put the "Amount" from Company1 in a field
Then "Amount" from Company2 is added in another field
Then the two new fields are subtracted from each other to create a difference
On preview we get this result.
