It looks like you want to measure what percentage of customers fit into a specific Purchase Brand. Pls confirm
Hi! Thanks for responding,
The objectives is to find how many customer's only buy the exact same brand after their 2nd purchase.
Pl find attached as per Superstore data. Change as per your need.