Hi Everyone,
Could some one please help me with a solution for pivot tables in alteryx. I tried using summarize tab but it seems to have some errors.
The input is as follows
| Primary credit | Supervisory credit | 1-30 | 31-60 | 61+ | Not past Due |
| A | U | | 31-60 | | |
| A | V | | 31-60 | | |
| A | X | 1-30 | | | |
| D | Y | 1-30 | | | |
| A | Z | 1-30 | | | |
| B | X | 1-30 | | | |
| C | Y | | 31-60 | | |
| D | Z | | 31-60 | | |
| A | X | | 31-60 | | |
| B | Y | | 31-60 | | |
| C | Z | | 31-60 | | |
| D | X | | 31-60 | | |
| A | Y | | | 61+ | |
| B | Z | | | 61+ | |
| C | X | | | | Not past Due |
| D | Y | 1-30 | | | |
| A | Z | 1-30 | | | |
| B | U | 1-30 | | | |
| A | V | 1-30 | | | |
| B | X | | | | Not past Due |
| C | Y | | | | Not past Due |
| D | Z | | | | Not past Due |
| A | X | | | | Not past Due |
| B | Y | 1-30 | | | |
| C | Z | 1-30 | | | |
| C | X | 1-30 | | | |
| C | Y | 1-30 | | | |
The output should be as below.
| Supervisory credit | Count of 1-30 | Count of 31-60 | Count of 61+ | Count of Not past Due | |
| U | 1 | 1 | | | |
| V | 1 | 1 | | | |
| X | 3 | 2 | | 3 | |
| Y | 4 | 2 | 1 | 1 | |
| Z | 3 | 2 | 1 | 1 | |
| Grand Total | 12 | 8 | 2 | 5 | |
| | | | | | |
| | | | | | |
Appreciate your help!
Thanks
