How to find out Percentile values

Hi,

I've attached my sample sheet where i want to find percentile .

I've used the calculation=PERCENTILE([% of F by Org],.25). This gives the correct result for one column. But i want to find Percentile (column F) where it should exclude the current row and find the 25th & 75th Percentile. Likewise for next row, exclude the current row value

I've to do this logic in both Alteryx and Tableau.

Please take a look at attached file and let me know if it can be achieved in Alteryx & tableau both.

Workflow

Accepted answers

All comments

Hi @AnandKumar1

I want to ask why do you want to exclude the current row 🤔

Because the business wanted to know if they exclude one row or ID ,how much will be the Percentile and how much it deviates from original percentile?

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703