Pivot Table (Multi-Fields)

[knnwndlm]

Hi SME,

I would like to create a pivot table similar to Excel in Alteryx as shown in the attached file.  The Source tab is the raw data and the Desired Output tab is the pivot table.  

Could you please help me figure out a way to do this?  I can do it if I only have one number field. For some reasons, I'm not able to get the two number fields to work.

Thanks,

kwl

[knnwndlm · Accepted solution]

Thank you @ShankerV !  Able to follow the first half but stuck on the second half without the actual workflow.  

[ShankerV · Accepted solution]

Hi @knnwndlm 

Few minutes please, getting the issue fixed. 

did many changes in the summarize tool and union tool.

Many thanks

Shanker v 

[ShankerV · Accepted solution]

Hi @knnwndlm 

The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[knnwndlm · Accepted solution]

Thank you so much for your help @ShankerV!  Have a wonderful day!