topic Re: Summarize Tool in Dev Space

Summarize Tool

AS — Thu, 23 Sep 2021 05:49:19 GMT

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

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

Thanks in advance

BetterFerret — Thu, 23 Sep 2021 06:19:52 GMT

AS,

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

atcodedog05 — Thu, 23 Sep 2021 06:54:17 GMT

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 — Thu, 23 Sep 2021 08:40:44 GMT

AS — Thu, 23 Sep 2021 08:41:24 GMT

Thanks for replying Always 😊

atcodedog05 — Thu, 23 Sep 2021 08:42:04 GMT

Happy to help : ) @AS

Cheers and have a nice day!