Return value of a field based on value in another expression
I need to return the transaction type of the latest transaction as per below. That is, for a given stock item/customer/project etc. as defined in the cyclical dimension group, I can find the last transaction date using max(TransactionDate). What I need to do is to return what that transaction was e.g. Customer Order, Customer Invoice, Credit note etc.