RE:Same Top 10

[Chanty4u]

hi all,

I have small doubt.

For example i hve  top 10 sales 100  for product "A"

and same for top 10   sales 100  for product"B"

i want to get top 10 sales ?

what will be the result?

[sasikanth]

HI,

If the values are same

ex:

41,300

42,300

43,400

44,500

45,600

it will take according to the sorting order of the dimension

[sathishkumar_go]

I am not understanding ur question.

If u see the data, sales coordinator have one employee (Emp id 😎 salary is 65000

what you are expecting?

-Sathish

[Chanty4u]

how to get max second  higest?

[sathishkumar_go]

that means rank value = 2?

-Sathish

[sasikanth]

If you want to get it in a text object then

FirstSortedvalue(Sales,-ID,2) --> will give 2nd max value

[Chanty4u]

higest year salry is  80000

second higest is   70000

I need to get that value?    2nd higest value

[sathishkumar_go]

Are you want, each title top 5?

-Sathish

[sathishkumar_go]

=rank(aggr(sum([Year Salary]),Title,[First Name]))

-Sathish

[gireesh1216]

[gireesh1216]

The above function returns the original ranks.....