7 Replies Latest reply on Apr 10, 2018 10:28 AM by Mike Mainzer

    Sum By Top Values in Groups

    David Tarasenko

      Hello,

       

      Here is the basic problem. Assume the following simple table, which list the number of views of an article (K#).  I would like to sum by grouping the top 2 (10 + 9 = 19), the top 4 (10 + 9 + 8 + 7 = 34), the top 6 (10 + 9 + 8 + 7 + 6 + 5 = 45 and so on.

       

      In my real world example, I have about 6800 articles inputted with associated article views and I would like to graph (bar chart) the number of views from the top 50 read articles, then the top 100 (which includes the top 50), and so on.

       

      Any thoughts on the easiest way to do this?

       

      KAViews
      K110
      K109
      K38
      K47
      K86
      K65
      K54
      K23
      K72
      K91