6 Replies Latest reply on Mar 8, 2017 4:33 AM by Tushar More

    How to show average of top N %, instead of every observation?

    Andreas Rønn

      Hi,

       

      I've found out how to show top N%, but instead of showing each observation in sorted order, i just want to show an average of the top N % observations.

      I've included a package workbook of the superstore sample. In this workbook my question corresponds to showing average of all top N % customers profits, and not every customer in top N%.

       

      Thanks,

       

      best regards, Andreas