Help On Rank Function

[#1]

Hi All,

can any one help me regarding the following issue please:

I have a report containing the Loan and outstanding data. Below is an example

I have to show the top 3 Customers for Loan or for Outstanding. I tried with a pivot table in qv by applying the Rank() Function.

When I tried with the following details

Dimention - Customer name

Expression- Loan, Outstanding, =Rank(Loan), the Rank function is working fine. But When I am putting all fields as Dimention(Country, Name, ID, Group and Industry) the Rank function is not working and only showing 1 all entry. (I need to show all the fields in the table)

Can you please help me, where I am going wrong.

Attached is the sample for reference.