I need to show max sale person from list of sales persons can you please help me
Can you please provide some data?
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
Could you please be a little more specific?
In a first guess, I would recommend you to use Set Analysis.
set as --persons field as dimension and sum(sales) as expression and on dimension limits tabs select top as 1.
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
hope this helps you
Retrieving data ...