3 Replies Latest reply: Jul 13, 2011 8:51 AM by Frank Beunder RSS

    Show obly the max value of a Accumulation

    Frank Beunder

      Dear all,

       

      I have a little question. In a Pivot table I use a RangeSum to Accumulate Values and on top of this I use a RangeMax tot determine the Max value of the Accumulation:

      RangeMax(Top((RangeSum(Above(Value,0,RowNo()))),1,NoOfRows())

       

      Now I only want to show the rows which contain these MAX values, but I dont know how to do this.

      Please have a look at the attachment.

       

      Does anyone have a idea how to do this?

       

      Thanks in Advance!

       

       

       

       

       

       

       

       

       

        • Re: Show obly the max value of a Accumulation
          Stefan Wühl

          Hi Frank,

           

          I assume that you don't need to filter or re-order the accumulated values during runtime (which will give you a new max value and associated station).

          If so, you might put the accumulation into the script. Evaluating the max in the chart is easy then and you get your desired table ( see attached qvw).

           

          I know that this is a kind of workaround and probably not your favorite approach. I am not so deep into the inter record functions as some of the gurus here probably are, but I have the feeling that the range functions themselves prevent us from not showing the Null or zero values.

           

          But maybe I just have missed some point,

          Stefan