I am trying to get the top 0.90 percentile for NPS score and participatoin of some departments. The data is as such

Now, in Jupiter notebook, I am able to write the code for percentile for both, as shown below

But since, in Quicksight, nesting of aggregated function is not allowed, I am not able to arrive at the same scores.
For your reference, NPS value is %Promoters - %Detractors
Can someone guide me as to how this number can be achieved?

Hi @Max , so like I mentioned, the enps is an aggregated column; a calculated field - where we calculate %Promoters - %Detractors. To this, I am getting the error of nesting of aggregated function is not allowed. So need a work around for this.