calculate daily rank

[mattheomx]

I have the following scenario: user selected a Milk from Product selection box.

The requirement is to display the daily ranking based on Sales for the last couple couple of days for product Milk. The resulting table should look like this:

Date	Rank
3/3/2015	5
3/4/2015	2
3/5/2015	4
3/6/2015	4
3/7/2015	6
3/8/2015	4

How can this be achieved?

[chrislofthouse]

See the application ! ! attached.

[mattheomx]

Thanks for the help but this solution doesn't work.

I reloaded the app with a different number to differentiate the sales. For 08/03 and  07/03 it works correctly. 06/03 and before have incorrect ranks:

[chrislofthouse]

Is this any better?

[mattheomx]

Here's a catch: when I select milk rank changes to 1:

The rank should stay as if there was no product selection. We should see rank 1 and rank 2 depending of the day.

Really appreciate the help!

[chrislofthouse · Accepted solution]

Ah sorry, I misunderstood your requirements:

[mattheomx]

Great thank you!