Want to find maximum in whole column and based on that need to calculate percentile.
Note: I can find the maximum value from API and pass it to Pivot table, but it won’t work when I filter/aggregate data.
Please find attached to check percentile.
any alternate solution for above query would be much appreciated.
It seems you can write such formula in WebDataRocks.
The formula will look like this one: sum(“value”) / max(“value”) * 100.