Rank with Ties

Comments

2 comments

  • Avatar
    Elliott Herz

    Hey Malinda,

     

    In your RANK function, you can specify whether ASC/DESC as well as the type of ranking (handling ties). So you can create a metric which is your RANKing, and clearly specify the different types:

    EXAMPLE: RANK(SUM([Revenue]), "DESC", "1224")

    The options are "1234", "1224", "1334", "1223".

    Let me know if that makes sense.

    Best, Elliott

    0
    Comment actions Permalink
  • Avatar
    An Y

    Hi 

    I am trying to use RANK in a multi-pass scenario but having no success, could anyone help please?

    Basically I have a Pivot with Rows='GroupName'  and Values='Denominator'.  I have to add column2 to pivot  that shows the average of the Top 10  lowest Denominator values in column1. With the formula shown below I am getting an average of all the Denominator values , not just the top 10 in ASC.

    Raking rule : same rank for duplicate Denominators, and no skipping .

     

    Thank you

    AY

    0
    Comment actions Permalink

Please sign in to leave a comment.