Hi all. I have a table with 3 columns:Date,Customer Type,Product. I am trying to create a ranking of products based on the customer type and the series of products this particular type has selected in a timeline.In other words i want to find which product a particular type of customer selects first, which second and so on.. I use the rank function but i'm not getting the desired result.Any help would be appreciated.
