Cumulative trend view

[sankar_ganesh]

SalesDate	Product	Sales
08-May	a	5
10-May	a	10
12-May	a	25

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!

CalendarDate	Latest Sales
08-May	5
09-May	5
10-May	10
11-May	10
12-May	25
13-May	25
14-May	25

Regards,

Sankar

[Anonymous]

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