the solution may depend on how you retrieve data from both static and dynamic reports and what's capability of editing your data source in tableau as well. Could you give some more background information?
So both reports are from Salesforce
1. Static report: I download the report from the start of the quarter and never update it again
2. Dynamic report: I download the report every new day which is why the values could change over time
Both are manually uploaded and refreshed as data sources connected to tableau.