Rank using Unique Item

DeveloperCYT

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

 

Misbah

@DeveloperCYT 

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

 

 

 

DeveloperCYT

Perfect, thank you