ax 2012 queries with aggregat

Got request from customer to list all item (and variant) with their latest cost price

so this is the solution (download the xpo here)

you can see we are using aggregate max on activation date,