How to show top 3 and bottom 3 values

[#1]

Hi There,

I want to show top 3 and bottom three performance of the Agents how can i found that please provide the details. Let suppose there are 10 agents and its performance in amounts.

Thanks in advance.

Jude

[its_anandrjs]

Hi,

I suggest you have to represent the data some thing by aggregate the values of the sales do you have any sample file.

Rgds

Anand

[#3]

Hi,

Like a agent has values 5000,4000,200  it will come in top three

and another way 145,148,720 this are bottom three in data so haow i can show it. I attched my sample file see it

Jude

[lironbaram]

hei attach is an example

hope its helps you

[its_anandrjs]

Hi,

You have to aggregate the data by rank function like

Aggr(Rank(aggr(sum(Sales),Agent)),Agent) 

and

Sum( Sales )

Rgds

Anand

[its_anandrjs · Accepted solution]

Hi,

You have to use some thing like in sample file see attached sample file.

Rgds

Anand

[#7]

Hi,

That is what i am looking for in two different chart is good way to represent.

Thanks

Jude

[#8]

Hi, Liron,

Your solution is also correct but i want in different charts.

Jude