Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Dev Space

Customize and extend the power of Alteryx with 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
22 - Nova
22 - Nova

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
22 - Nova
22 - Nova

Happy to help : ) @AS 

Cheers and have a nice day!