Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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