Summarize Tool

[AS]

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 

Code	No	Yes	Grand Total
10		45
11	45	`85
12	14	774
13	52	748
14	55

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

Thanks in advance 

[BetterFerret · Accepted solution]

AS,

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

[atcodedog05 · Accepted solution]

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

Hope this helps : )

[AS]

thanks @BetterFerret  

[AS]

Thanks for replying Always 😊

[atcodedog05]

Happy to help : ) @AS 

Cheers and have a nice day!