How to sum repeat members

[former_member758749]

I have some repeat members in the data, and I need to sum the values and delete the remaining ones.

e.g., from this columns,

The result must be:

Keep just the first key and sum the Total Space and the Occupied from the tow rows.

And so on for all the repeat members.

Thanks!

[avsalynin]

why do you need it at the model level? In stories / applications, the measure (in table or chart) will still be summed up by repeating codes / keys.