Rank with Multiple Dimensions but don't get the - for duplicates or same values

[jbentley]

From other posts, have found the way to get the rank to work correctly, but have two needs.

1)  Would like to avoid the 5-6 when there is a tie.  I'm ok with it listing 5 5 and then 7 for the three series numbers

2)  I would like to also calculate the minimum of 5 different ranks being calculated

1)  =if(All_NRx>0,
aggr(rank(sum(All_NRx)), [NSS Territory Name], [NPI Number]),
99999)

you'll see a few that have like 28-30 where there are ties when calculating the same on the Branded NRx field

2)  Is there a way in the same chart to then calculate the Minimum Value of the Rank All NRx, Rank Branded, etc.  Each of these are similar code to above in 1...just changing the All_NRx to Branded_NRx, Branded_TRx, etc

[a_mullick]

Hi,

To answer 1), check the documentation for Rank() and the various paramters you can supply. It sounds like you probably want to use fmt = 1:

Regards,

Azam

[a_mullick]

For 2) I think you can use the RangeMin() function (which you can extend to reference your 5 columns) e.g.:

Regards,

Azam