Use a single date filter for two transaction tables in GUI Model

Hi :wave:

How can I join and summarize two different transaction tables with a common date filter?

For instance, assume I have two tables called Cash Sales and Bank Sales, both having a standard DateTime field with Customer Name column

How can I create a summary table in this format with a single Date filter?

Filter: Date
|Customer | Cash Sales | Bank Sales|
|ABC | 29993.23 | 233242.23|
|XYZ | 32413.33 | 113344.12|