3 Replies Latest reply: Aug 23, 2017 12:28 PM by Sunny Talwar RSS

    One selection selects multiple fields

    Prasad Mundewadi

      I have Opportunity data as shown. Each opportunity has a closed date and a created date. Also a day of quarter.

       

      Oppty          Created Dt          Closed Dt          Created Day of Qtr          Closed Day of Qtr

      111               1/1/17                 31/1/17               1                                        31

      222               1/31/17               2/15/17               31                                     46

      333               1/25/17               1/31/17               25                                     31

      444               2/2/17                  2/20/17              33                                     51

       

      User wants to make 1 selection on a 'Day of Quarter' e.g. 31 and that should give him the 1st 3 rows above.

       

      Is there a way to achieve this?