Top N Customers based on multiple conditions

[#1]

Hi,

My requirement is as below.

I need to show the Top N customers based on below conditions.

§ Report should consider only customer where "Economic Capital >= 1 million USD".

§ Top N customer selection should be done on "Economic Capital Percentage", which is calculated based on the last month's EC and this month's EC.

Rest of the customers than top N, should be treated as "Others" and aggregated. They should also appear on the report

My report always shows 2 periods data. ANd in one of teh report, i am displaying Top N countries based on below condition on the dimension.

=if(aggr(rank(Sum({$<PeriodID = {$(=max(PeriodID))}>} BookValue)),Country)<=vCustNum,Country)

So in the similar way how to generate Top N customers for multiple condituons. Please suggest.

[#2]

HI Mani,

Use

1. if(economic capital > 10000000 , Cutomers) ---------------- > dimension

2. make a Variable TOP and also use the same in input box at Front sheet.

3. Now got to chart properties > presentation and enter variable "TOP" in max number in chart.

4. Chart Properites > Sort ......do in decending order.

In this simple way too you can achieve you top Customers. N = variable enter in input box.

Please let me know if it works at u r end

[#3]

here i have to consider 2 conditions for selecting the Top N customers.

1. Customers whose EC > 1000000 and

2. %EC change (Top N %EC change) -- here %EC change is current and Prev period %EC change.

Can we put these 2 conditions in a calculated diemnsion? If so, how to do?

[#4]

Can you share your application... it will be easy for me to sort it out 🙂