mutiple row filter based on date coulmn from other table

[Alteryxnewbie27]

 

  

Hello All,

I need some help in filtering the rows from  table 1 based on the date coulmn  value <= "highest number of products sold on" coulmn from table 2. Thanks in advance!

[JosephSerpis · Accepted solution]

Hi @Alteryxnewbie27 I mocked and approach with annotations to explain how to tackle this challenege.

[nagakavyasri · Accepted solution]

Hi @Alteryxnewbie27  try this:

[Alteryxnewbie27 · Accepted solution]

Thank you @JosephSerpis  and @nagakavyasri !!