group by

[tuncfiratvb]

Hi,

In my data I have different session_id,counterpartyid,instid,total balance ecl columns. What I want to do is to sum total balance ecl column according to counterpartyid and session_id (group by function). 

for example when I filter 147 session formula must show sum of total balance ecl according to counterpartyid column.

(in 147 session for 11111 counterpartyid total balance ecl must be 258+487=745)

Thanks for any help in advance.

[abhijitnalekar]

Hi @tuncfiratvb ,

If you want to show the total in the table then just remove the instid you will get the desired total.

I hope you are looking the same.