Top 10 sales in set analysis

[#1]

How may i get top 10 sales in set analysis, anyone can u briefly explain it?

[Anil_Babu_Samineni]

If your answer is solved please close this thread with correct answer

[prasadmundewadi]

I have already a complex set analysis and then on top of it want to add the top 10 condition.

e.g. Need to get the sum

Opportunity with the Top 10 Values with below conditions:

1) Status <> Omitted

2) Current Qtr Flag = Y

3) Won flag = Y

Sum({<[Status]-={'Omitted'}, [Current Qtr Flag]={'Y'}, [Won Flag]={'Y'}>} Value)

Now where do i add the Rank in the above set analysis?

[sjaiswal13]

Hi Prasadmundewadi,

Did the rank with all the conditions combination work for you?

Thanks,

Sonam