@NiviPower : Yes, this seems to be possible. Once the request get approved, at the back end you have to do some parallel operation filter a query based on (Country->Region->State->City) and pass it to the SharePoint view so that SharePoint view gets filtered according the query. You can then either user to export this data for the reporting purpose.

 

Or else same can be achieved through PowerBI to which you have to use Power Automate and PowerBI connectors.

www.000webhost.com