4 Replies Latest reply: Jul 13, 2016 4:16 PM by David Capan RSS

    Find max value within a date range

    David Capan

      Hello,

       

      I'm trying to find the max value within a certain date range that I have set dynamically using set analysis.

       

      For example,  in the table below I have a date range, set to go back a certain amount of days based on the max date, along with the individual sums for those days. 

       

      What I'm trying to figure out is how to get the max value for the date range.

         

         

      Date7/10/20167/9/20167/8/20167/7/20167/6/20167/5/20167/4/20167/3/2016
      individual433232312321452432292444
      max452452452452452452452452

       

       

      Any ideas?

       

      Thank you for your help.