Unique Values

[Learner09]

Hello All,

I am trying to pick only Unique value from the specific column. Please see the details in attached file and advise.

Thanks,

[echuong1 · Accepted solution]

There are a couple of ways to do this, but I think the easiest is with a multi-row.

I essentially created a formula grouped by customer code, checking to see if the cost is the same as the cost above. If it is, it should be 0.

[Learner09]

@echuong1 Thank you. It's Perfect!