Hello everyone,
I am working on a dataset with arount 10 million rows that looks like this
week Product Sales
week 1 A 592
week 1 B 38
week 3 A 15
week 2 F 4589
... ... ....
... ... ....
... ... ....
my goal is to have an output that is a table of the highest 3 seling products for every week like this
week product sales rank
Week 1 A 589 1
Week 1 C 65 2
Week 1 D 40 3
Week 2 F 1589 1
Week 2 A 689 2
Week 2 E 200 3
.... ...; ... ....
does anyone know how to achieve this ??
thank you so much
