2 Replies Latest reply on Sep 25, 2019 4:59 PM by Gajendra Singh

    Aggregate Data

    Gajendra Singh

      Hi,

       

      I have a data set as shown below. In this set, if my current month-1 matches with previous month year, then aggregate all months sales under the set. For example, for the highlighted in yellow we have Aug 19 sales, so in output i should get aggregated total of each month sales under the set.

       

      For example, for below data set output will be

       

      CSA-001746     0010     CC     12883 (which is sum of -23180 and 10297)

      CSA-002205     0010     CC     -150 (which is sum of -1500, 177, 1038, 135)

       

      Rest rows will be ignored since there are no Aug 19 sales.

       

      Thank you.

      GS