Problem to Display Top 10

[prezan20pec]

Hi All,

I have a problem in displaying top 10 records.

I have a situation like this. I have table where there are emails sent out to some of the users in the country. I have also a measure called as Average.

So there are three columns: Country, Delivered and Average

I have aggregated the rows at Global Level and I want to see the top 10 rows  based on the Average.

Also I want to apply one another condition - only records having delivered > 1500 should come and then ranking should be applied on Average.

When I apply any one of the condition it is working but when I apply both it is not working. Pls help.

Thanks.

[PRIT AMRIT]

Have attached the solution for you, see if it helps?

Thanks
Prit