Filter second table dynamically by 2 columns

[Anonymous]

Hi all

I have a revenue table. This table has 2 important columns, the date, and the year.

I need to show revenue for this table, and also the revenue of the selected date last year.

I copied the table (rev1 & rev2), added rev1 a column "dateLastYear" and created a relationship with "dateLastYear" from rev1 and "date" from rev2.

This works.

But now, it should also filter the year. When i select year 2019 in rev1 table, it should filter rev2 for only show 2018.

Left is rev1, right is rev2. rev2 also has revenue for 2019, but i only need the values from 2018.

[Anonymous · Accepted solution]

Solved it by adding a custom column to both rev tables.

rev1 got combined column from date + year (date last year and year -1) and rev2 got combined column date + year.

The created relation solved my issue.