Show most recent transaction for customer (Dynamic cube)

[DanielN]

Hi,

I hope someone is able to help me, because I am lost for ideas.

I am looking to create a data item to put in a list with CustomerNumber. The data item has to show the most recent purchase / transaction for each customer in the list. I have Date (DD-MM-YYYY) available in my dynamic cube. Due to the nature of dynamic cubes (I'm assuming), I am not able to use the maximum() function as I would use on a relationel connection.

Its a simple list with: CustomerNumber and MostRecentPurchase as the only two data fields.

Fyi, I am not able to make the change in the db or framework manager, so it has to be in report studio.

Best regards,
Daniel