Filtering a pivot table or result set based on presence of grouped values

[#1]

Hi all,

I have attached a qvw to better illustrate what I am after.

I have a pivot table which groups on a value called REFKey

Within this, there would be a number of projects, each one with values such as System and Actuals.

a Project's system can be 1 of 2 values 'Clarity' or 'RM'

The data is coming from a single concatenated result set from the script.

what I want to do is ONLY show 'REFKEY' values that have the presence of BOTH 'RM' and 'Clarity' within them.

Does that make sense?

I would prefer to do this in the script, rather than on the Pivot table

Thanks in advance!

Matt