4 Replies Latest reply on Oct 22, 2018 4:25 PM by Adi Nalla

    To get the first date of previous year and its value

    Adi Nalla

      Hi All,

       

      I am working on a weekly data set that looks something like below,

       

      Category     Subcategory    Weekend Date   Dollars

      Fruits          Apple                 1/1/2016                 $36

                                                    1/7/2016                $12

                                                      -                             -

                                                      -                             -

                                                   12/15/2016               $24

                                                   12/22/2016                $12

                                                   12/29/2016                $12

                                                     1/5/2017                  $45

                                                     1/12/2017                $56

                                                     1/19/2017                $34

                                                             -                        -

                                                             -                        -

                          (Current week)    10/22/2018             $67

       

      I am trying to get the 'Dollars' value for First date of previous year which is 1/5/2017 and $45 to show the value for 'Apple' Category.

      I am trying to show the value without bringing the Date to the view, like below

       

      Category     Subcategory     Dollars

      Fruits          Apple                  $45

                        

      Any help on this? Thank you.