Zoho Pages Embedded Report - Relative Date Filter Based on Parameter

Zoho Pages Embedded Report - Relative Date Filter Based on Parameter

I have a report (bar graph) embedded in a page with months along the x-axis. I want to apply a relative date filter (e.g. trailing 13 months based on a parameter passed to the report. I see the built in relative filter like last or previous n number of months but I want to filter last n number of months based on a date in the past.

For example. If today is 29-Aug-2022, I want to be able to pass a parameter to the report, say a date 31-May-2022, and filter relative to that the last n number of months from 31-May-2022.

Is there a way to do this?

I've attached a screenshot of what I have so far. I can apply a filter like this to the table but can't figure out how to do it for the report.