Forum Discussion

IlliaShliapuhin's avatar
IlliaShliapuhin
Frequent Visitor
3 years ago

Quintiles calculation (calculated column)

Hello Guys,

With the data set below, I need to get a calculated column with quintiles (from 1 to 5) for each year based on the values in the column Value.

Many thanks if someone can help with it.

 

Need Help

3 Replies

    • IlliaShliapuhin's avatar
      IlliaShliapuhin
      Frequent Visitor
      3 years ago

      ryan_mayu the logic is to calculate quintiles for each year for each company. For each year I want to assign a quantile to every company based on values we have in the Value column, whether the value figure belongs to the 1 or 2 or 3 or 4 or 5 quintile
      Does it make sens?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  IlliaShliapuhin ,

     

    Here are the steps you can follow：

    1. Create calculated column.

    Column =
VALUE(
PERCENTILEX.INC(
FILTER('Table',
[Year]=EARLIER([Year])
)
,[Value],.5))

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly