RRDI: how to report on related artifacts of the same type?

The original discussion began in https://jazz.net/forums/viewtopic.php?p=62157

So I have two queries:
Query1. "Requirements" returning the following values and filtered to return all Requests of Type='Requirement'
..
..
..
..
..

Query2. "Features" returning the following values and filtered to return all Requests of Type='Feature' + .. = 'Bug' or .. = 'Test Case'
..
..
..
..
..
..

So I now get two sets of results:
Query1. SHowing me all Requests of Type Requirement with the related Requests of type Feature (if any)
Query2. All Requests of Type Feature with the related Requests that are not requests of type Requirement

Now I want to show this in a single table/list eg.

Requirement 1         total(relatedTestCase.attributeX) total(relatedbugs)

------>Feature 1        sum(relatedTestCase.attributeX)  count(relatedBugs)

------>Feature 3        sum(relatedTestCase.attributeX)  count(relatedBugs)

Requirement 12        total(relatedTestCase.attributeX) total(relatedbugs)

------>Feature 2        sum(relatedTestCase.attributeX)  count(relatedBugs)

------>Feature 4        sum(relatedTestCase.attributeX)  count(relatedBugs)

First question is how do I get a data item for Query2 that sums the values of "attributeX" for all Related Requests that are of Type ='Test Case'?
Next I need to get a data item for Query2 that counts the number of related Requests of type = 'Bug'?
Next I need to get a total of attributeX for all of a Requirement's related Features.
I also need a total of the counts of Bugs of all a Requirement's related Features.
Finally I guess I need to do a join between the two queries, what do I specifiy as the link parameters? Query1... linked to Query2...?

Thanks

The original discussion began in https://jazz.net/forums/viewtopic.php?p=62157

So I have two queries:
Query1. "Requirements" returning the following values and filtered to return all Requests of Type='Requirement'
..
..
..
..
..

Query2. "Features" returning the following values and filtered to return all Requests of Type='Feature' + .. = 'Bug' or .. = 'Test Case'
..
..
..
..
..
..

So I now get two sets of results:
Query1. SHowing me all Requests of Type Requirement with the related Requests of type Feature (if any)
Query2. All Requests of Type Feature with the related Requests that are not requests of type Requirement

Now I want to show this in a single table/list eg.

Requirement 1         total(relatedTestCase.attributeX) total(relatedbugs)

------>Feature 1        sum(relatedTestCase.attributeX)  count(relatedBugs)

------>Feature 3        sum(relatedTestCase.attributeX)  count(relatedBugs)

Requirement 12        total(relatedTestCase.attributeX) total(relatedbugs)

------>Feature 2        sum(relatedTestCase.attributeX)  count(relatedBugs)

------>Feature 4        sum(relatedTestCase.attributeX)  count(relatedBugs)

First question is how do I get a data item for Query2 that sums the values of "attributeX" for all Related Requests that are of Type ='Test Case'?
Next I need to get a data item for Query2 that counts the number of related Requests of type = 'Bug'?
Next I need to get a total of attributeX for all of a Requirement's related Features.
I also need a total of the counts of Bugs of all a Requirement's related Features.
Finally I guess I need to do a join between the two queries, what do I specifiy as the link parameters? Query1... linked to Query2...?

Thanks