4 Replies Latest reply: Feb 11, 2015 11:12 AM by Richard Chilvers RSS

    Maximum of a set of selected values

    Richard Chilvers

      I have a chart showing sales values, and I allow the user to select which week or weeks they would like to show the values for. So they might select weeks 3,4 and 5.

       

      I would like to have an extra chart which shows the total value from week 1 to the max week selected (so weeks 1-5 in my example).

       

      Is there a function to select the max value in this way ?

       

      Thanks

      Richard