11 Replies Latest reply on Nov 13, 2017 7:29 AM by Shinichiro Murakami

    Find Top X Percent On Unsorted Data

    Stephen Bava

      I am trying to get an accurate running sum even when the data isn't sorted correctly. E.G. see below (left), notice how the running sum is based on how the sales are sorted. In this case, it is giving me a running sum, but not the running sum by highest sales. See below (right), I sorted the sales and now the running sum is correct. The issue is, folks will filter every which way, causing the running sum to change. How do I get the running sum to compute by highest value regardless of filters?

       

      Workbook attached.

       

       

      Left                                                                                                    Right