Dynamically sum rows based on columns

[Sohdaw]

Hi,

I have a set of data which goes by the below:

Legal Entity	Group	Activity	Account	Bank	01-Jan-2023	02-Jan-2023	03-Jan-2023	04-Jan-2023	05-Jan-2023
THF	EGF	CEN	123456	AAA	0.0625	0.0625	0.0625	0.0625	0.0625
THF	EGF	CEN	123456	AAA	0.1	0.1	0.1	0.1	0.1
THF	EGF	POS	123456	AAA	0.047	0.047	0.047	0.047	0.047
THF	TRF	VOL	234567	AAA	-0.03	-0.03	-0.03	-0.03	-0.03
THF	RET	OPS	345678	BBB	0.02	0.02	0.02	0.02	0.02
KLD	AFT	CRU	567890	CCC	5.98	5.98	5.98	5.98	5.98

The date range changes depending on which date i am running (if im running for T, then the dates start from T-1 to T+N). 

Please advise how i can dynamically sum based on Activity + Account? 

eg. 

Legal Entity	Group	Activity	Account	Bank	Sum of 01-Jan-2023	Sum of 02-Jan-2023	Sum of 03-Jan-2023	Sum of 04-Jan-2023	Sum of 05-Jan-2023
THF	EGF	CEN	123456	AAA	0.1625	0.1625	0.1625	0.1625	0.1625
THF	EGF	POS	123456	AAA	0.047	0.047	0.047	0.047	0.047
THF	TRF	VOL	234567	AAA	-0.03	-0.03	-0.03	-0.03	-0.03
THF	RET	OPS	345678	BBB	0.02	0.02	0.02	0.02	0.02
KLD	AFT	CRU	567890	CCC	5.98	5.98	5.98	5.98	5.98

Thanks 

[Felipe_Ribeir0]

Hi @Sohdaw 

One way of doing this 

[ArtApa]

Hi @Sohdaw - Here is one more solution. Same logic as above, but more compact: