Calculate with multiple tables

Hi Jinji

Go to Edit Queries

Click on the table in which you want to add new column.

Click on "Add column" on Tool bar

Add custom column with name 'Price UP' and write the logic as  (2016 Price - 2015 Price)

Go to File > Apply & Close

Thus your changes are saved.

Jinji - had a quick play with it as the totals werent adding up. You can do a merge of the tables using a full outer join through query editor. Then add this conditional column

Then I renamed some columns and deleted some and added a custom column:

This then calculates the total difference properl