Hi people
I have the attached data and I need to create an object based on the column called Dimension. Basically, for each account number, if the Dimension column has A in it, then all rows for that account number are flagged as A. If A is not in the list but there is B, then B is flagged with all the rows for that particular account number. In other words, A wins over B, B wins over C and C wins over D.
What’s the best way how to go about it please?
Thanks.
If I read correctly (always suspect)
Required Value = Min([Dimension]) In([Account Number])
1 Like
Thanks a lot. Great thinking out of the box. 