Please refer to this previous answer that is similar to your problem:
You will need to do Data Scaffolding. Concept and method here:https://www.kenflerlage.com/2019/03/date-scaffold.html
If after reading you are struggling to understand, you can share a mock version of your data and I can help you.
Hope this helps If does, can I ask you to mark it as helpful and correct? this will help other users to find correct answers and will allow us to close the thread. Many thanks!