Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

DV - Formula to get the Top 10 high values in the given field

Received Response
31
Views
4
Comments

Summary

DV - Formula to get the Top 10 high values in the given field

Content

Hi Team,

 

Can anyone help me in getting top 10 high values in the given column? Please share if any formula in DV. I need only top 10 rest data I do not need to come in the report.

 

Thank you....

Answers

  • 3473493
    3473493 Rank 3 - Community Apprentice

    Hi Gianni,

    Thanks for sharing...I have another challenge could you please help me on the same...

    I have date format which is MM/DD/YYYY format for example 5/31/2017 ...I need the output in the format of '31-May'  could you please assist me on this....Thank you

  • Never underestimate the power of Google

    https://www.youtube.com/watch?v=YguwxIwk9qc

  • Capture.PNG

    Simpy adapt the format for the column to what better match your needs...

    PS: try to not "hijack" your own thread, one question per thread as the content must also help others (and nobody can guess to find a date formatting info into a Top10 thread)

  • 3473493
    3473493 Rank 3 - Community Apprentice

    Hi Gianni, Thank you for your suggestion and solution.