Populate values from above

[don_qlikview]

Hello,

I have this table where i have to populate the '0' values from above values. I tried using the above() but it seems it works only one time. For example if have a value on first row and the below 2 rows are empty then the second row gets filled by above() but not the third. I am using three other list boxes namely Year, Type and PC Name as a filter to get to the values shown in the attachment. So, can anyone help me how i can populate the other rows??

Thanks,
Don

[JonnyPoole]

you may need to use the range functions to check multiple rows above but i'd like to see you QVW test example before being confident in a solution. Attach it if you can.