I have a table as shown in below. Based on CLEAR_DATE,I want to show case like this FY20,FY21. DATE DP PTERMS 10/19/2020 -35 N 030 7/30/2020 -28 N 000 3/5/2020 N000 3/10/2020 N000
Not able to understand the exact requirements, can you share the expected output, I don't see CLEAR_DATE in the shared data, is it the first column 'DATE'?
