group by

tuncfiratvb — Tue, 26 Oct 2021 07:15:19 GMT

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.

Re: group by

abhijitnalekar — Tue, 26 Oct 2021 07:29:03 GMT

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.

topic group by in Search the Community

group by

Re: group by