Report of project hours for transfer pricing

Hi Community,

I'm asked to name the logged hours of a project for transfer pricing. I thought it was a simple thing, but...

I do have:

- logged hours by project, each project containing its domestic legal entity (e.g. Project 1, Headquarter, 200h; Project 2, South Africa, 100h);

- legal entity is a custom field used both for projects and WRIKE user

I'd like to pivot the mentioned information, but failed with reports, analytic board & dashboards.

Any recommendation other than Excel exporting?

Best,

Raimund