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
