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

Highlighted

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 ) 

 

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

 

Ps:- Sorry for bad english

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

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

@Sai_Bharadwaj_Venati 

 

See if this helps

Misbah_0-1587739747535.png

 

Highlighted

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

Thanks Man, Saved the day!