Group distinct values

[#1]

Good morning, I have this problem:

I have two fields in a table. In a column there is a code (for example OLX111, SDO123, etc.) and in the second column is the amount.
How can I group the values of the first column? I would group them for the first three characters.

Regards

[sunny_talwar]

May be like this:

Dimension:

Left(code, 3)

Expression:

Sum(Amount)

[Clever_Anjos]

Something like this?

LOAD

    LEFT(Code,3) as NewCode,

    Sum(Ammount) as SumAmmount

Resident yourtable

Group by LEFT(Code,3) ;

[#4]

Thanks Cleber, it's work correctly.

[#5]

Thanks Sunny, it's ok.