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.