Thank you so much Aayush!
I have one more question, sorry.
If you look at the table above, is there a possible way I can pivot them in Excel by keeping the number of customers? As you can see, one customer (Cust_ID) can perform transaction in different month, under different segment, with different cardtype, can be both online or retail spending, and performed transaction either locally or overseas. Therefore there can be millions of observations and I can’t export this to Excel.
Is there actually a way to keep the number of unique rows after rolling up to customer_id level (in my first question)? The reason why is because I need to remove the cust_id (sensitive information) later and just show the number of customers in order to do pivoting. Does my question make sense? Hehe sorry.
I might be overlooking something…