Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Can you share any sample file for that.
Rgds
Anand
try this
sum({1} IF(AGGR(RANK (Total(sum({1} sales))),[Salesrep Name])<=25,sales ))
Hi Sunil,
What is meaning of {1} in your code could you explain it why using it two times.
Rgds
Anand
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.
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