You can use Level of Details (LOD) expressions to achieve this.
The formula is pretty long but the idea is basically like this:
1. Aggregate the Total Occurences for each combination of [8 Digit Code] & [Value]
2. Then, at the level of [8 Digit Code], get the highest (max) occurence value
3. When value in step_1 equals step_2, give me the [Value]
You can look at the result of each step in tab "step breakdown'.
If this is your first time using LOD, check out our learning resources - onlinehelp / tutorial / blogs to understand more on LOD.
It's a very powerful expressions that you should never miss
Mode.twbx 75.5 KB
Awesome! Thank you so much for your help!
Been using LOD but not this hard core