Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

TopN with duplicate values in column

I want to show top 10 deals by amount $ however the 10th value is 50K and we have multiple 50K accounts so it shows too many lines (way more then 10).

 

I have the filter set to Top 10 Account Names by value Amount $.

 

Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous ,

    I have a little confused about your requirement.

    Normally, for the duplicate values in rank, here are the parameter Dense and Skip in RANKX function for to handle this situation.

    So what is your desired output? Please share your desired output based on your data sample so that we could help further on it.

    Best  Regards,

    Cherry

     

     

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous ,

    I have a little confused about your requirement.

    Normally, for the duplicate values in rank, here are the parameter Dense and Skip in RANKX function for to handle this situation.

    So what is your desired output? Please share your desired output based on your data sample so that we could help further on it.

    Best  Regards,

    Cherry