I have a database of transaction data with 3 columns: customer ID, transaction date and transaction value.

Each row is one transaction. A customer can have several transactions.

I have identified using the summary view the latest transaction date for each customer (2 columns: customer ID and last transaction date).

I now want to make analysis on this new data but I need to transform the summary view into a table in order to drill down the data.

How to do that?

Thanks in advance,

Louis