Hi everyone,
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