Skip to Content
0
Former Member
Feb 12, 2014 at 10:38 AM

Facing Duplicate issue with Rank Function

727 Views

Hi All,

I am facing issue with Duplicate value with Rank function.

For e.g: I have one dim called customer group, and their Actual Values which is a measure value. I need to show Top 5 Customer Based on Actuals.

I am using Rank function(V_Rank([Actual];[Customer group];TOP)) to show top 5, but it is given 6 Customers when there are 2 Actual is Same.

See below Screenshot for Reference.

You can see in above screenshot, there are actuals is same 71.79 at 5th level, I am also using the Block level condition to show only 5 Customer (V_Rank in list (1,2,3,4,5)).But based on same Actuals it is showing me 6,

Can any one help me to show only 5 customer,

Thanks & Regards,

Akhil Muley

Attachments

Capture.JPG (41.3 kB)