Get last month of the selected year containing non-blank values
Dear gurus,
I am developing the report in which I need to sort the distributors in descending order by the stock QTY at last month within the selected year. If selected year is history, then Month should be 12, if 2012 is selected, then Month should be 2 as last month stock was reported is February. Could you please elp with the formula?
