Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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
3473493
3473493 Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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

  • Gianni Ceresa
    Gianni Ceresa Mod

    Never underestimate the power of Google

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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.