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

[markus19-85]

Maybe I will do an sum(Amount) in Script first, so can add double postings already there, I think that should work.

Thanks for your help

[sunny_talwar]

Not a problem. Remember to close the thread as and when you get what you wanted by marking correct and helpful responses

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny