Urgent!! How to get previous month when production happened?

I have a product list, Month dimension and i can see monthly Production datas in the module . I want to get the Last month when production happened for all the products (let's take one product as example - where production happened on Dec-19, Jan-20 but no production in Feb now when i see the line item Last month of Production i need to see Jan-20 in Feb & March months ) 


 Dec 19Jan-20Feb20Mar-20
Last Prodn Month  Jan 20Jan 20


Ps:- Sorry for bad english

V.Sai Bharadwaj

Connect on LinkedIn


Best Answer