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