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

[#1]

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?

Thanks in advance.

Best regards,

piroglu1907

[#2]

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

[its_anandrjs]

Hi,

Can you share any sample file for that.

Rgds

Anand

[SunilChauhan]

try this

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

[its_anandrjs]

Hi Sunil,

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

Rgds

Anand

[SunilChauhan]

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.

[its_anandrjs]

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