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