time spend on a product

hello
I have projects with activity and people imputing worked time on activities : so far so good
I have products and each product is linked with 0 1 ou N projects , but a project can only be linked to 1 product.

I would like to know for each product how many worked time has been inputed on each project linked to this product.

Why ?  : The products are my softwares : i want to know the time spent on a particular projetc but i also need the time spent on a software (on all the projects linked to this product)

There doesn't seem to be a report showing that

I thought that maybe I could export some data and do the computation in a spreadsehhet but when I export to spreadsheet the projects it doesn't show the linked products and when I export the products it doesn't show the linkd projects ...

any idea on how I could get this information ?

regards

I see what you mean

It is a good workaround and it would work but not in my situation : I already have a quite complex project hierarchy with 4 or 5 levels and for a given product (software) the linked projects are in different part of the hierarchy

This is why I tried to use the products