5 Replies Latest reply on Oct 25, 2016 6:57 AM by Samarth pp

    Need help with Max and Min Ratio Range

    Samarth pp

      Hi

       

      I'm trying to calculate Min and Max ratio for a selected time period and display the values as

      Ratio: "0.00%-0.50%" in the report.

       

      Window_Max function works only when I have a period dimension in the rows. But, we can not use the period in the rows. The requirement is to show the Min and Max Value for the selected time period from the slider.

       

       

      I have attached the sample workbook (V 9.3) and the requirement screenshot. Please let me know if there is any way to do this. Appreciate your response.

       

      Message was edited by: Samarth pp