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

Sai_Bharadwaj_Venati

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 ) 

 

ProductA
	Dec 19	Jan-20	Feb20	Mar-20
Qty	20	50	0
Last Prodn Month			Jan 20	Jan 20

 

Ps:- Sorry for bad english

Misbah

@Sai_Bharadwaj_Venati 

 

See if this helps

 

Sai_Bharadwaj_Venati

Thanks Man, Saved the day!