Calculatetable with variables

I have 2 Tables called Tour_Details :

and Contract_Details:

I would like to make a table using these two tables to make a third table Tour_summary.

Preferably using CALCULATETABLE and each column in the table Tour_summary should be a VAR.

The Column Day has the SUM of tours taking place for each SubVenue in a day,

Week has the number of tours taking place in that corresponding week.
Month, in that corresponding month and so on.

Any idea how I can achieve this?

Thanks