Fill null value with previous not null value in expression

[Anonymous]

A sample data set is : (empty cells = null data)

Required output is:

Can I achieve this using expression?

Currently I use "Before", but it doesnt work properly. It worked in August column, but went wrong in Dec.

[sergio0592]

And if you try with :

rangesum  (before(sum(Your_indicator),1,2))

[Anonymous]

yes i mean using rangesum with before

exactly like that

[sunny_talwar]

May be try this

Before(Column(3))

Assuming that the Cumulative (A-B) is your third Measure

[Anonymous]

my measures are very dynamic, it will appear based on user's selected measure

so Cumulative (A-B) will not always be my third measure

[sunny_talwar]

May be use the expression label in that case....

Before(LabelName)

[Anonymous]

Hi

I dont think I can use that.

Here I attach my latest qvw.

it went wrong when I select only 1 month, the table will show all month data.

[sunny_talwar]

To fix this with selection, you will have to perform this action in the script... no way to do this on the front end (at least that's what I think)

[Anonymous]

Could you help me to fix it by using script?

since I'm not very familiar with it

Thanks

[sunny_talwar]

Can you check now if this meets your requirement