5 Replies Latest reply on May 10, 2017 12:34 PM by Lisa Li

# Top 10 Country with out filter

Can i calculate top 10 country based on population using calculated field , I have done it with filter but want to know if this can be done using other method.

I have tried doing it using Rank but rank being a table function , it is not giving desiered result-.

• ###### 1. Re: Top 10 Country with out filter

Hello Kunal,

Can you elaborate on why table calcs aren't giving you the desired result or what your desired result is?

-Lisa

• ###### 2. Re: Top 10 Country with out filter

actually I want to filter out top 10 country based on sales and put it in the map-. I am using Sale here to make it more complicated-.

I have created a cal field -

Countrywise Sales-

{ fixed ( country ) : sum( Sales) }

Cal field 2 -

Top 10 rank -

Rank ( Countrywise Sales ) < 11

but this is not working , In table calculation, we need to mention weather it would be rab

le accross or pane accross , how will you know that when u are putting it in a map instead of a table-.-.

• ###### 3. Re: Top 10 Country with out filter

If you have the Country field in detail on the marks card, you should be able to compute the rank using Country.

Hope this helps!

-Lisa

1 of 1 people found this helpful
• ###### 4. Re: Top 10 Country with out filter

Thank u , Its working fine. Another thing , Can you pls

let me know , if i create a filter using top 10 by sum sales and do show filter from filter pane , Why the filter show "
Limit top 10 by sum(sales)) , how to get rid of it ?

• ###### 5. Re: Top 10 Country with out filter

Why do you want to show the filter? With the way your view/filter is built, I don't think you can get rid of it. If you explain your desired end result I can give some work arounds.

-Lisa