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 .
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.
