Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dynamically sum rows based on columns

Sohdaw
8 - Asteroid

Hi,

 

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

Legal EntityGroupActivityAccountBank01-Jan-202302-Jan-202303-Jan-202304-Jan-202305-Jan-2023
THFEGFCEN123456AAA0.06250.06250.06250.06250.0625
THFEGFCEN123456AAA0.10.10.10.10.1
THFEGFPOS123456AAA0.0470.0470.0470.0470.047
THFTRFVOL234567AAA-0.03-0.03-0.03-0.03-0.03
THFRETOPS345678BBB0.020.020.020.020.02
KLDAFTCRU567890CCC5.985.985.985.985.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 EntityGroupActivityAccountBankSum of 01-Jan-2023Sum of 02-Jan-2023Sum of 03-Jan-2023Sum of 04-Jan-2023Sum of 05-Jan-2023
THFEGFCEN123456AAA0.16250.16250.16250.16250.1625
THFEGFPOS123456AAA0.0470.0470.0470.0470.047
THFTRFVOL234567AAA-0.03-0.03-0.03-0.03-0.03
THFRETOPS345678BBB0.020.020.020.020.02
KLDAFTCRU567890CCC5.985.985.985.985.98

 

Thanks 

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @Sohdaw 

 

One way of doing this 

 

Felipe_Ribeir0_0-1672763055016.png

 

 

ArtApa
Alteryx
Alteryx

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

 

ArtApa_0-1672799561696.png

 

Labels