Request for Email Activity Report with Internal/External Breakdown - exchange online

Hi everyone,

Is it possible to generate a report that shows the number of emails sent and received by each user, with a breakdown of internal and external emails?

I understand that we can find some basic metrics in the admin center under Reports > Usage > Exchange > Email activity. However, this does not separate the count of internal and external emails.

Does anyone have any suggestions or know of a way to achieve this?

Thank you!