Creating a Percentile values column for a given column in data table

Could anyone pls tell me, How to create/ calculate Percentile values  from numeric data present in a column of given data table in template/ dashboard using Spotfire client ??

I have tried with creating a calculated column like- "Percentile ([column],15.0)" using custom expression. But, this option is not working fine. It is not giving the desired output of Percentile values for the input column. It is showing the same particular value of the input column repeating for all the rows..

(2) Answers