SOLVED
Summarize Tool
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Printer Friendly Page
AS
8 - Asteroid
‎09-22-2021
10:49 PM
- Mark as New
- Subscribe to RSS Feed
- Permalink
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
Solved! Go to Solution.
Labels:
5 REPLIES 5
22 - Nova
‎09-22-2021
11:54 PM
- Mark as New
- Subscribe to RSS Feed
- Permalink
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 : )
‎09-23-2021
01:41 AM
- Mark as New
- Subscribe to RSS Feed
- Permalink
Thanks for replying Always 😊
22 - Nova
‎09-23-2021
01:42 AM
- Mark as New
- Subscribe to RSS Feed
- Permalink
Happy to help : ) @AS
Cheers and have a nice day!
