Product Logic WRT Date

Hi Everyone,

Please find the below records.

Products Date

P1 2019-07-20

P1 2018-01-24

P1 2018-08-21

First I need to take the maximum date of a particular product. In the above example, Max date is 2019-07-20.

I need to display this record in the month of 2020-07-20 ( After 365 days). My viz is month wise chart with year filter. I need to display this product count in july 2020 month.

Requirement:

I have thousands of products which has multiple dates. I need to take the maximum date of products and need to display COUNT of products after 365 days taking maximum date.(Above Example)

Regards,

Koushik.