I've created a new thread here as well https://support.google.com/analytics/thread/186986520?hl=en

It seems challenging. One suggestion that has been given to me is to do our own modelling on the data so we can try replicate how the Google models the data for GA4 reports

Has anyone found a solution for this?