# Rank using Unique Item

Options

Hi,
I have a module which shows change in volumes by Customer - Product (over 5000 lines)

I then rank these changes largest to smallest, and have a view of that.

 Customer Product Last Month Current Month Change Rank Customer A - Product 1 340,480 311,576 -28,905 1 Customer A - Product 2 70,326 46,326 -24,000 2 Customer D - Product 1 403,775 394,675 -9,100 3 Customer C - Product 3 23,387 16,393 -6,994 4 Customer A - Product 4 17,029 10,226 -6,803 5 Customer A - Product 5 72,600 66,631 -5,969 6 Customer A - Product 6 17,000 12,525 -4,475 7 Customer D - Product 2 10,572 6,180 -4,392 8 Customer A - Product 7 112,126 108,801 -3,325 9 Customer B - Product 2 32,446 29,364 -3,083 10

Now what I need to do is extract the top 3 customers from this, without duplicates
i.e Customer A has the 2 biggest changes but the customers I want are A and D and C

 Cust - Rank Customer 1 Customer A 2 Customer D 3 Customer C 4 Customer B

I have tried many ideas but can't seem to solve this one.

Thanks

Tagged:

Options

See if this helps!

Step 1: Create Customer List if it is not already available.

Step 2: Use the following calculations ( Rank Line will be calculated once the second module is created)

Step 3: Create the module where you will be checking for Max values against customers

Step 4: Reference Rank in the first module from second module.

Hope that helps

Misbah

Miz Logix