TOP N With Multiple Condition

[Anonymous]

Hi Guys,

Need a little help here.
I want to top 10 of my clients based on their total revenue and a client score that i calculate.
I can just use one filter in the filter pane.How can i achieve this?

[leandroab1]

You can contatenate the variables you want to see the TopN and use it in the Filter.

In my example I created a new column with Date, Equip and Name. So basically I selected this new field and filtered the Top 5 Loads per day.

[knowparthshah]

@Anonymous ,

Client	Total Revenue	Client Score
Client1	100	70
Client2	90	80
Client3	80	150
Client4	70	90
Client5	60	100

As per the logic you require, which clients should be selected as Top 3 ?

[Anonymous]

@knowparthshahSince i have many clients if i rank top 5 according to client score, i will get many clients so to again rank them i need to use the total revenue.