FIRSTOCCURANCE should happen based on High number

Options
g.mahesh
g.mahesh Member, ALL USERS, Certified Model Builder Posts: 4 Occasional Contributor
in Planning & Modeling

Hi All,

 

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.

Capture.PNG

 

Please suggest.

 

Regards,

Uma

 
Tagged:

Categories