Hello Folks,
I'm trying to Capture the last value of a measure before the blank record appears in the column on Measure "Unit Price" in below screenshot.
Now, the challenge in below screenshot is for all the MONTHS (Jan to Dec), its a Bex Structure, therefore a STATIC column. Meaning if i run the Application given at any month of the year, i'll always see that structure, regardless i run in Apr, July or Sept.
Some thought?
Option 1 - We can capture each row by applying array loop iteration
Apply code for forEach(function(element, index) to locate blank cell.
Now, we know it can only be applied to a Dimension and in my case Dimension(Bex Structure, will never be blank).
Option 2 - Most Probably not the best way to do it.
DS.getData (measure, selection).
Repeat the above code 11 times covering all months and then Run If and Else statement to locate blank cell and then capture the cell before that.

Highly appreciate your wise advice, thanks
Add comment