6 Replies Latest reply: Oct 2, 2011 1:01 AM by Anand Chouhan

# Can I show Top 25 salesman with detached display using set analysis?

Hi,

I have countries and sales amounts (per sales representative) and would like to show a table for top 25 salesman in each specific country and then take averages of it. I am using straight table.

Dimensions:

Region

Salesrep Name

Expression:

=IF(AGGR(RANK (Total(sum(sales))),[Salesrep Name])<=25,sum(sales ))

However, my expression is selection dependant. I would like to detach it permanently so that we will always see top 25 sales rep in each country.

To be able to do that; I was trying to change my expression into:

=IF(AGGR(RANK (Total(sum({1<REGION={Singapore}>}sales))),[Salesrep Name])<=25,sum({1<REGION={Singapore}>}sales))

However, it is still selection dependant. (if I choose other countries from listbox, this table does not bring any figures). Would you have any suggestions?

Best regards,

piroglu1907

• ###### Can I show Top 25 salesman with detached display using set analysis?

Hi,

I think you have to use some thing like this .

Dimension:

[Salesrep Name])

In the expression you give   =sum({1} sales)

Sort by Descending order of the expression .

In the Presentation tab give Max Number as 25

Rgds

DS

• ###### Can I show Top 25 salesman with detached display using set analysis?

Hi,

Can you share any sample file for that.

Rgds

Anand

• ###### Can I show Top 25 salesman with detached display using set analysis?

try this

sum({1} IF(AGGR(RANK (Total(sum({1} sales))),[Salesrep Name])<=25,sales ))

• ###### Re: Can I show Top 25 salesman with detached display using set analysis?

Hi Sunil,

What is meaning of {1} in your code could you explain it why using it two times.

Rgds

Anand

• ###### Can I show Top 25 salesman with detached display using set analysis?

Good question anandi

{1}-. used for all and not to select any thingthat is like deatttach.

where ever you write sum or aggr function it need to put {1} in order to create deattach functionality.

Anand,if you have question then make a seperate post so that people should not distract.

• ###### Re: Can I show Top 25 salesman with detached display using set analysis?

Hi,

I could not understand it what you explained, Do you have any sample to explain it if so thanks for you in advance.

Let me know its not urgent yet.

Better if you explain it in example.

Rgds

Anand