I have a situation where I need to show a table with 3 columns - Country, Re-certification date and Re-certification status.
Twist is, a Year filter should be provided and the status column should change dynamically according to the selection of the Year filter -
For example –
If 2022 is selected in the filter and some of the Re-Certifications don’t expire in 2022 (Re-Cert. Date is available for 2022) then the Re-Cert. Status shall be updated as ‘Complete’, else it should show the status as in excel and for the past years, if the certification is not extended (not ordered or complete - and nothing further) then the status should show 'expired'
Similarly, when 2023 is selected, the record numbers shouldn’t change, only the status should be changed for the Re-Cert. Status column
Note - When any of the year is selected, the record numbers should not change, rather the Re-certification status should change