We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Subtotal needed for data sets

Myusrename001
8 - Asteroid

Team,

I need to subtotal the numeric at the same time it should also divide if the subtotal is more then 25 and pick the reference number from dataset and also do the subtotal till 25.  

 

can anyone help me - please. 

 

Thanks,

 

Data SetSubtotalsOutput
242424
12525
194419
14520
55025
5555
96414
67020
17121
5765
189423
19524
71027
11038
11049
2412824
91379
113810
1615416
1216612
3 REPLIES 3
Sebastiaandb
12 - Quasar

Hi @Myusrename001 , 

 

Here you go :-). 

 

Sebastiaandb_2-1649862292527.png

 

 

Sebastiaandb_1-1649862280221.png

 

 

Greetings, 

 

Seb

 

Myusrename001
8 - Asteroid

Thanks so much ! 

Sebastiaandb
12 - Quasar

Hi @Myusrename001! My pleasure! Could you  mark my post as a solution :D?! 😅

Labels
Top Solution Authors