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....
You may try using PERCENTILEX.INC Function or RANKX Function.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021