Graph Help: Comparing an individual to a Team without

[#1]

What am I trying to compare is an individual along side the average of everyone elses number...I can't figure it out...

I have 20 employees and I want to show how this employee selected is comparing to the other 20....

Thanks

[#2]

I've attached the Qlikview App along with Set Statement that wasn't working along with the solution you gave me which is working :).

Thanks again...I'm looking for a similiar number like the Set Example which would give me the Top Sales Person even if I don't have them selected.

I hope the upload worked.

Thanks

[johnw]

OK, see attached.

Dimension = if(aggr(rank(SUM(AGGR(IF(SUM([YTD Net Rev]) - SUM([PYTD Net Rev]) > 0,SUM([YTD Net Rev]) - SUM([PYTD Net Rev]),0),CustomerName))),Corpsales)=1,dual(Corpsales,1),dual('ALL OTHERS',2))

Expression = SUM(AGGR(IF(SUM([YTD Net Rev]) - SUM([PYTD Net Rev]) > 0,SUM([YTD Net Rev]) - SUM([PYTD Net Rev]),0),CustomerName))

[#4]

Hi John, thanks for the repsonse...

It's very close for what I'm looking for...

What I'm trying to do is...if I Select Scott on the Corpsales that in the report I still hold what the amount is for the top Sales Person. Similiar to the Set Command but can't figure out how to make the rank work with it for one person.

The help is very appreciated...

[johnw]

Ah, OK. Apply a liberal sprinkling of {1} then? Or a liberal sprinkling of {<Corpsales=>} if you want all other selections to still apply. Attached uses {1}.

[#6]

I'm not getting how to move the rank feature has an expression...

I would to show always the Top Sales Person in the Columns as data...

Thanks again for the help...