Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
1/7/2021
1/11/2021
2/5/2021
2/24/2021
1/26/2021
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'?