Hi I have a below set of data and I have create a Year filter ( Year is derived from "Expiry Date"). I want to get the count When 2020 is selected in the filter it should count from Max date to the Min date the count of status Red, Green and Yellow and same with Year 2021, 2022 and 2023. Can you please help.
@Chanty4u , thanks for the input. I used the below code but the "Expiry date" is not getting selected when I select 2021 in the year filters please see below SS. I want to select "Expiry date" from Max date to Min date when selecting on the year filter. can you please help how to achieve this