Forum Discussion
TOP N With Multiple Condition
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?
3 Replies
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.
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 ?
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.
