Weighted Calculation

[#1]

I've attached an example of a weighted calculation I'm trying to do. The chart shows what I'm ultimately trying to get to, which is the "Weighted Confirmed Response Rate" calculation. I'm able to do the calculation easily enough in the chart but what I really want to be able to do is do the calculation in the text box entitled "Weighted Confirmed Response Rate". I can do the calculation in the text box if I hard code out all of the sources, but I'm looking for a more elegant way to do that, especially since new sources can be added or removed which would make the hard coded option extremely manual. I'm sure there is a way to do it with "Aggr" or "Set analysis", but I can't seem to get the text box to equal the 28% (27.99%).

Any help would be much appreciated.

thanks,

rob

[#2 · Accepted solution]

I was able to get it figured out by using an "Aggr". I've attached the example QVW as reference for anyone else trying to do something similar.

rob

[#3]

Thanks. It is what I am looking for.