I have multiple tables in a Google Data Studio report:

Table 1 (Input):

Table 2 (Input):

_{Note: One Year From Date is a calculated field based on the Date field: datetime_add(Date, interval 1 year)}

When I add a date range control, it filters based on the date that all the calculated fields are based on (Date field). For example, if the date range control is from Jan 1, 2022 to Jan 31, 2022, the results are:

Table 1 (current output):

Table 2 (current output):

with the desired outcome being:

Table 1 (expected output):

Table 2 (expected output):

How do I get the filter to filter based on the actual date rather than the calculated field original date?

Google Data Studio Report