0 Replies Latest reply: Sep 28, 2014 11:13 PM by Rachel Boey RSS

    column display only the 1st value of the month group by store

      Hi, I currently have this table:

       

      DateStoreValue
      1-JunA4
      2-JunA2
      3-JunA7
      4-JunA3
      5-JunA5
      1-JunB9
      2-JunB3
      3-JunB4
      4-JunB4
      5-JunB8
      1-JunC6
      2-JunC3
      3-JunC9
      4-JunC5
      5-JunC2

       

       

      How can I have the 'Value' column to take the 1st day of the month value?:

       

      StoreValue
      A4
      B9
      C6

       

      Thanks.