I have made an app that generates two pivot tables, is there a way to compare the data without extracting the data into a new application.
The pivot tables are basically showing transactions between companies, debit and credit, therefore they need to be reconciled together to ensure that they match, please see example below.
For example, Company 2 receives £5 from Company 1, therefore in one table "Credit", there is a positive value of £5. This should therefore be reflected in Company 1, "Debit" table, with a negative value in in respects to Company 2, please see below.
I am trying to get to position, where I can generate the tables below as well as have a comparison table. In the example below, the transactions between Company 4 and Company 3 shows an error as the values do not reconcile. Therefore, the comparison pivot able will show the difference in reconciliation.
Hi, you can show credit and debit in one table to check differences, maybe you need to change/add something in your script so the vertical and horizontal dimensions are the same for both metrcis, so you end with a table that only shows differences
