hi guys, I have a large dataset which contains reject reasons. rejection reasons are order, kind like the waterfall. I want to count how many ppl are rejected by each rejection code. For example, customer b is rejected by "low+bro", because in the order, bro is the first reason, so b will be ONLY counted to bro, not low. raw what I am looking for is name rejection rejection_by_order rejection_reason count a low bro bro 3 b low+bro eas eas 1 c bro low low 1 d eas+bro e eas, low
... View more