Find the top 10 item in dynamic date range based on condition

Hello, I would like to ask some help how to find the top 10 item in the continuously changing date range based on condition.
Please, give me some advice!

The sample file has been attached!


Thanks in advance the reply!

Hello AlKey,

Thank you for your attention!
Almost good for me just by the number of frequency should be rank the items and the highest frequency product should be in "rank 1".

Hello again,

Please, ignore the last post, I could change your formulae.
Thank you for your help!

See you!