How can i veiw Max sale of person

[#1]

Hi Friends,

I need to show max sale person from list of sales persons can you please help me

[prma7799]

Can you please provide some data?

[avinashelite]

if you want to show in the charts, you can try with the dimension limits option in the chart properties

Or if you want to get it in a text box you can you rank() function , please elaborate more

[jduarte12]

Could you please be a little more specific?

In a first guess, I would recommend you to use Set Analysis.

Best regards.

[buzzy996 · Accepted solution]

set as --persons field as dimension and sum(sales) as expression and on dimension limits tabs select top as 1.

[gautik92]

if you want to show in charts you can use dimension limits if you want to use in text box you can use rank () function

[Chanty4u]

hi

sum(Dimension)

Max(Dim)

Min(Dim)

count(Dim)

hope this helps you

Thank you

Suresh

[hariprasadqv]

Hi,

Dimension: Name

Expression: max(sum(sales))

[#9]

if(aggr(Rank(max(sale)) =1,Saleperson),Salesperson)