Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!
SOLVED

Summarize Tool

AS
8 - Asteroid

Hi Expert,

 

I have a small query and need a quick solution. I'm using a summarize tool and I want Code in the rows , Comments as the column and and grand total

Expected output 

CodeNoYesGrand Total
10 45 
1145`85 
1214774 
1352748 
1455  
    

Attaching workflow that I tried but couldn't achieve the goal

 

Thanks in advance 

5 REPLIES 5
BetterFerret
8 - Asteroid

AS,

You are using the wrong tool.  The tool you want is Crosstab.  I have added it to your flow and attached.

atcodedog05
21 - Polaris

Hi @AS 

 

You can achieve this using crosstab tool with below config. This will give you Yes and No as different column and Sum of it in total column

 

atcodedog05_0-1632379957549.png

 

Hope this helps : )

AS
8 - Asteroid

thanks @BetterFerret  

AS
8 - Asteroid

Thanks for replying Always 😊

atcodedog05
21 - Polaris

Happy to help : ) @AS 

Cheers and have a nice day!