Fill missing ProductID: if ProductID is missing or '0' for particular Customer then fill with last month ProductID for the attached data(Missing Produ

[ankitpate7]

Dear All,

I have below problem statement with attached test case.
request to help me on this to populate missing product ID's

I have tried many ways in qliksense but unable to get it.

Thanks in Advance!

Problem statement :

Fill missing ProductID: if ProductID is missing or '0' for particular Customer then fill with last month ProductID for the attached data(Missing ProductID)