Total time spent sum on linked issues by roadmap

[Miguel_Silva]

Hi everybody!

I’ve defined a new dimension for cloned issues that is working pretty well.

With it, I can retrieve the time spent on one clones as seen here:

To do that I’ve defined a new calculated metrics “Clone Hours Spent”:

DefaultContext((
[Issue].[Issue].GetMemberByKey([Cloned from].CurrentMember.key),
[Measures].[Hours spent]
))

Now, as for the second step, I needed the sum of all “Cloned Hours Spent” by Roadmap (defined as a row and page), with the data above it would be something like this:

Thanks!