0 Replies Latest reply: Sep 29, 2011 7:43 AM by U R RSS

    Help On Rank Function

      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

      untitled.bmp

      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.