So now I'm a bit confused. I've tried both methods but must admit that it's beyond me.
I've attached a much cut down version of my qvw in the hopes someone can help.
n.b. I've had to use Set Analysis that may seem redundant in the attached QVW but is needed to narrow down the data in the original QVW which is many times larger with dozens of Services and hundreds of Servers, Metrics and Submetrics.