Forum Discussion
Filter second table dynamically by 2 columns
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 t...
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.
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.