How to classify data based on percentile

[Anonymous]

Hi:

I have a question regarding classifying companies based on their revenue. . Following is my data

What I want is that,

• Based on what I select in Filters (TechName, Region, Country and DataYear) some companies are short listed.
• Then I want to rank those companies based on their revenue percentile, as " 3 = High, 2 = Med and 1 = Low", as follows, ,
  • If(revenuePercentile > .75, 3, if(revenuePercentile < .25, 1, 2))
• Question is how can I calculate the revenuePercentile that's also dynamically updated based on group of companies being filtered.

I am quite new and any detailed solution/help will be highly appreciated. I tried using fractile() function but can't really figure out as how to use it.

stalwar1‌

[Anonymous]

I am adding an expression in the above straight chart as follow,

if(Revenue>=Fractile(Total Revenue, 0.75), 3,

   if(Revenue<Fractile(Total Revenue, 0.25), 1, 2))

Does it make sense, , if not then what's the best way to do this?