If the date isn’t relevant to the calculation of the ranking, you shouldn’t include it in your partition.
item_sales_countover = countOver({Sales_Person}, [Item, {Sales_Person}], PRE_FILTER)
ranking = rank([{Sales per Item} DESC], [Item], PRE_FILTER)
Does this result look right?
