Formula for Time Period of Last Input
I have a reporting module that reports actual performance on 12mth, 3yr, 5yr basis. It is dimensioned by quarters and teams input information in relevant quarters e.g. Q4 2020, Q3 2020
How do I create a summary module that picks up:
1. Latest input quarter - I've tried LASTNONBLANK
2. 2nd latest input quarter (i.e. comparison quarter).
Any help is appreciated,