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