String Data Type Series

Hi All,

We have one series (Trx Group) with String data type which is editable field. We are entering the values like (ABC123, XYZ 123).

Lets say we have hierarchy which consists of Item (Lowest Level), Sub Family, Family. We have 5 items in subfamily, so for 4 items in that group have Trx Group values as 'ABC123' and one item with 'XYZ123'.

When we see Trx Group value at aggregated level (Sub Family) it is showing the value as 'XYZ123' because we used max function in server expression.

Problem : As max items contains the value as ABC123 in the group, we would like to see this value when we are viewing at aggregated level.