Display top 3 customers

[#1]

hi,

I want to get top 3 customers based on total balance(deposit column - withdrawl column) I have used Rank function where em getting all ranks based on total balance. Where highest balance takes highest rank number.

Ex: 10 refers to highest total balance.

I have used      below code in expression

Rank((Deposit_Amt - Withdrawl_Amt),4,0)

How can I refine it to get top 3 based on highest bal?

Regards,

Prajna

[saumyashah90]

Please mark it helpful if it really was

[#3]

hi,

The rank expression u had mentioned gives overall rank .

If I add year as a dimension rank is not varying w.r.t year.. its constant for all the year chosen. What could be done?

Regards,

Prajna

[saumyashah90]

You should not year in dimension.that doesnt make sense

make it as a filter and if customer data is associated with the date field than it should make the difference

[#5]

hi,

Year,month is my selection criteria I have taken cyclic drill to get the same. Based on that i want my ranks to be displayed.

Thanks and Regards,

Prajna