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

how to get subtotals for a column

syed_shab03
5 - Atom

how to get subtotals for a column which doesn't have any column that can be grouped with 

 

ytd

100

200
300
null
null
100
200
null
200
100

 

Please note that there should be 3 sub totals here

1 REPLY 1
flying008
15 - Aurora

Hi, @syed_shab03 

 

What are you want output?

 

录制_2024_07_15_15_56_57_243.gif

 

Input Output  
ytd ytdSum_ytdID
100 10060010
200 20060010
300 30060010
   60010
   60010
100 10030060
200 20030060
   30060
200 20030090
100 10030090
Labels
Top Solution Authors