How can I see only one line?

[markus19-85]

Hello Experts,

I need your help.

I am having a table which looks like this

!

but I would like to the it in this way

but also dynamically, so if I select Treaty 1 and 2 I want to see 1,2

also I do not want to use distinct, because bookings can have the same amounts for 1 Treaty

Any Ideas on that?

Regards,

Markus

[sunny_talwar]

This?

[markus19-85]

Thanks so far, looks good for this small App, to bad it is not working in my bigger App, I try to give an example with more Data

[sunny_talwar]

Sure

[markus19-85]

please have a look at the new upload, thanks

[sunny_talwar · Accepted solution]

Check attached

[markus19-85]

works so far, but you are using now distinct. what happens if I have exactly the same booking, Will I lose it?

[sunny_talwar]

I don't know what makes the unique combination where the duplication is present at? May be add them all as dimensions like this

Sum(Aggr(Amount, Loss, GenReUnderwritingYear, DimensionX, DimensionY...))

[markus19-85]

In my Database I have an SK for every booking, but when I use that Key I can not aggregate on Loss Level, can I?

[sunny_talwar]

All you need this is for the expression part... dimension's don't have to change.