14 Replies Latest reply: Apr 17, 2018 2:06 AM by Suhasini Metri RSS

    Prod_Id wise max date from the selected date range and the sales for that date.

    Suhasini Metri

      Hi All,

       

      I want Prod_id wise max Date from the selected Range(From _Date and To_Date),and I want the Sales for that Prod_id  for the selected range.

      Can any one help me to resolve that issue.I have attached the sample QVF.


      example:I have selected From_Date:01/01/2018 and To_Date:01/02/2018

      I want Output Should be  as below:

      Prod_id , Date,   Sales

      101,  01/02/2018,   20

      102,  01/01/2018,  30

      103, 01/02/2018,   30.