Comparative multiple expression chart with individual item and group of item
I am trying to figure out how to create a chart that has two expressions plotted so you can see the comparative difference between an individual item and a group value. The first expression desired would be the value from a selected item (in the attached example that would be a specific salesperson). The second expression is for comparison purposes against a group that the selected item exists within (in the attached example that would be salesgroup and I was trying to chart the median of sales for the group). Using the attached qvw, i would like to select the salesperson bob and see his sales values plotted on the same chart as the median(sales) from bob's salesgroup (group1). any help would be appreciated. thanks, pete
