Re: Display second record (max-1) based on selected end date
Firstly, thanks. Your feedback is accurate based on the question. However, realized I didnot communicate the requirement in its entirety.
Scenario (corrected): Based on selected end date (Always one selected), display 'Limit' value for 2nd Max Analysis Date (Max [Analysis Date] -1) for every record in rolling 12 month period. Re-attaching qvw and sample date.
Expected Output (Column 'Previous Value' needs to be calculated):