In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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