1 Reply Latest reply: May 14, 2014 11:11 AM by Antoine Frangieh RSS

    Cumulative trend view

    Sankar ganesh
      SalesDateProductSales
      08-Maya5
      10-Maya10
      12-Maya25

       

       

      Hi , above table is the source data for one of my reports. I need to create a table shown below to create a type of cumulative view which shows latest sales for each calendardate . Calendardate is in an inline table. Identifying latest results for each calendardate should be done in the UI expression as it has to be a dynamic one .

       

      Could some one help me to achieve this ? Thanks!

       

      CalendarDateLatest Sales
      08-May5
      09-May5
      10-May10
      11-May10
      12-May25
      13-May25
      14-May25

       

      Regards,

      Sankar

        • Re: Cumulative trend view
          Antoine Frangieh

          The ideal would be that on load (using the peek function), you would fill the missing values with the required figure and identify them using a certain flag (1 for filled, 0 for null)

           

          Then, in the front-end, you would create expressions that would calculate the sum using set analysis for values Flag = 1.

           

          That should give you both the required results to be displayed while giving you the correct sums.

           

          That is the easiest solution that I can think of.

           

          If you need more guidance, reach out.

           

          Cheers,


          Antoine