In the year 2014 I have 7 storage plants and when I select 2014 april I have only 4 storage plants and remaining 3 are missing that is Null it is not specifeid in the data base. for the Null values I need to take from the previous Month that contains the value that maybe 0 or anything
For example
2014 plant stock
tab 454
taj 222
tam 554
yrj 878
tje 986
fjfs 665
April2014 Plantstock
tab 88
taj 96
tam 54
here YRJ TJE and FJFS are missing so i want to search in the previous month for that storageplant has value or not