How to calculate top 30% of a item list?


1 comment

  • Joel Stewart

    I'd recommend reviewing the GROUPPERCENTILE function.

    With this function, one can identify the percentile grouping at an arbitrary level. If needed, later in the workbook, one could add a filter to display only results above or below this threshold.

    Comment actions Permalink

Please sign in to leave a comment.