My friend Dian Taylor published step-by-step instructions for creating a view that is impossible in the OOB in the Power Platform and Dynamics 365.
Here is a very similar, or actually precisely the same – but a lot easier – since I'm lazy!
D365 Goddess: https://youtu.be/RHQUIv3p6OA
Read more: https:/fetchxmlbuilder.com
Jonas Rapp: https://JonasR.app
XrmToolBox: https://www.xrmtoolbox.com