How to show dimension with 'random' description?

[heij1421]

Hi All,

I have a simple question, but I can't figure it out.

I have the following data

Code, Description, Amount

10,   Description10,           100

10,   Desription10,             200

20,   Description 20,          300

20,   DESCRIPTION 20,  400

Now I have a simple table with dimension 'Code' and expression SUM(Amount)

So far so good

Now I don't want to only display the Code, but also one of the descriptions. As you can see there are typos in the source data (desription instead of description). So when My dimension is Code and the second dimension is Description, than I have 4 rows instead of 2.

I want to group on Code and display one of the descriptions behind the code within that dimension.

I tried as dimension AGGR(Description,Code) but that doesn't work.

Thanks for helping.

[Gysbert_Wassenaar · Accepted solution]

Try AGGR(MaxString(Description),Code)

Or if you already use Code as dimension use an expression MaxString(Description) instead of using a calculating dimension

[heij1421]

Thanks Gysbert. The maxstring did the trick!