8 Replies Latest reply on Apr 12, 2018 7:59 AM by Peter Hanges

    Count number of records in a percentile

    Peter Hanges



      I have a measure called Amount, and would like to calculate the number of records above or below a certain percentile.  For example, if the 80th percentile is $100,000, then I want to count the number of records that have an amount >= 100,000. 


      What would also be interesting to see, is the average value of Amount above or below a percentile.  An example question would be: What is the average Amount for records >= the 80th percentile. 


      Appreciate any help!