Reply
Highlighted
Frequent Visitor
Posts: 7
Registered: ‎04-12-2018

Percentiles

 

Hi,

 

I have columns of <customers> and <sales>. I want to calculate the <sales> values, corresponding to the relevant percentiles of <customers>. (e.g. sales volume corresponding to the upper 1% of customers, upper 10% of customers etc....

 

Hayk

Community Support Team
Posts: 2,740
Registered: ‎07-09-2016

Re: Percentiles

@Hayk,

 

You may try using PERCENTILEX.INC Function or RANKX Function.

Regards,
Sam