I have figured out how to get the 10nth most recent date (or value) using FirstSortedValue() but I am still stuck on how to apply the aggregate function since using the returned date (it is really a datetime) for a greater than "If" does not work as it may not be unique and the one value on its own does no good.
To make things even more complicated I realize that I may not even have 10 records. In this case I need to get the sum or average of what is available.
So I should restate my problem to be to get the average or sum of a value on the Past 10 *or less whichever is greater* transactions.
Script query is seeming more immenent - please tell me there is another way