Filter dataset using Advanced Function (Decile)
I want to create a report filtering values from a column which are greater than 90th percentile in that dataset.
I can use Advanced function "Decile" to rank each value of the column assigning a value of 1 to 10 based upon its rank to the highest value, but I can't use this Decile function as filter (filtering values with decile greater than 9, I would achieve my goal, but it's not possible).
Is there any way to do this in Yellowfin?
Thank you in advance.