6 Replies Latest reply: Oct 5, 2017 9:14 AM by Subathra Barathiventhan RSS

    Date Generation Issue

    Subathra Barathiventhan

      Hi all,

       

      I have one year data(Fields are Date,Sales,Item,Branch)...i have to generate all dates between min(Date) and max(Date)..then i have to find cumulative sales for each Date(Order by Date)...

      i Tried this.. but it took 2 hours to  Generate cumulative for one month data...is there any Solution to reduce my loading time

       

      EX:(Input)

      Date           Sales

      1/1/2016    10

      3/1/2016    40

      4/1/2016    30

      6/1/2016    10

       

      Output should be like this

      Date           Sales

      1/1/2016    10

      2/1/2016    10

      3/1/2016    50

      4/1/2016    80

      5/1/2016    80

      6/1/2016    90