I have 2 columns, say entity_B and amount.
entity_B can have values, for example 151B,152B.
Each of these entity_B values have corresponding amounts.
How do I add the amounts for entity_B with similar formats?
Here’s an example:
entity_B - 151B, 154B, 161B, 163B, 171B, 172B etc
Corresponding amounts are - 10,20,30,40,50,60
I need the output something like this:
150A (151B+154B) ----> 30
160A (161B+164B) -----> 70
170A (171B+172B) -----> 110
Is there a good solution? I tried using calculated field, but didn’t work correctly.
Thanks in advance!