This content has been marked as final. Show 2 replies
Jason, if all you have a way of aggregating those ID numbers into a single row, then you could use MAX([Sales]) with Totals turned on to get the result you are looking for. Would that work for you.
This seems to have worked, thanks!