Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

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
20 - Arcturus

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
20 - Arcturus

Happy to help : ) @AS 

Cheers and have a nice day!