Creating pivot table

[PrashantJP]

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

[AZuc · Accepted solution]

@PrashantJP there are several approaches for this problem. See if this one helps you

[atcodedog05]

Hi @PrashantJP 

Here is how you can do it.

Workflow:

Hope this helps : )