Skip to main content

Hi team,

 

I have a list of TOP most popular products in cetain categories on a specific day for which I used the rank function.

 

I need to create a table with the price evolution for these specific prducts over a few months.

 

Since the TOP products change each day I need to somehow make them static.

 

So I need something like that, but the products that are listed need to be TOP products on my given day.

 

I appreciate any advice

 

Price evolution over time based on popular product on a specific day

1 answer
  1. Jun 28, 2020, 10:06 PM

    I am not clear on what the expected output should be. Please clarify. In addition, do attach your packaged workbook (twbx) so that any solution suggested is relevant and works for you.

0/9000