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?

[Chanty4u]

not dimension limit.

For example:in same product i hve    two top 10 values?   which will give the result

[gireesh1216]

hello suri.......

You have two products only.....product A,B

YOU CON'T FIND TOP 10 FOR 2 PRODUCTS

If You Have More then 10 products then only you can find top ten products......

[Chanty4u]

Please look into my data and qvw

in excel sheet 3data

[sunny_talwar]

What is the expected output?

[sasikanth]

Hi,

What do you want to achieve here?

[Chanty4u]

in my data

i hve  emp id  2  and yearsalry is 63000 for both    is hvng  two records so..  wen i use  dimen lim top 5  

how it is caluclates?

[sathishkumar_go]

Hi,

Please find the below screenshot for using rank function

-Sathish

[sathishkumar_go · Accepted solution]

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

-Sathish

[sathishkumar_go]

use if condition for top 5 or 10 values.

-Sathish

[Chanty4u]

that is okay.   in abve ur screen sht   

sales coordinator   sum(yearsalary)  65000

if i hve same   sales coordinator   sum(yearsalary)  65000

what will be the result?