FIRSTOCCURANCE should happen based on High number
Is it possible to get FIRSTOCCURANCE based on Highest Number?
As per the below Example:
1. "PRODUCT A" has the Highest Transaction number- 4,000 in the second Hierarchy(Bucket 2). "PRODUCT A" Will TRUE Under BUCKET 2 Parent.
2. "PRODUCT C" has the Highest Transaction number- 3,000 in the first Hierarchy(Bucket 1). "PRODUCT A" Will TRUE Under BUCKET 1 Parent.