How can I create this Pivot table exactly in Alteryx?

[Kinetic_analytics]

Hello:

Great people. How can I create this pivot table by using Alteryx?

I have added the data in the yellow Tab. Appreciate your help.

Thanks

[gautiergodard · Accepted solution]

Hey @Kinetic_analytics 

Here is one way to do it! You can tweak the column names and play around with the formatting as you see fit (perhaps using a table tool from the reporting pallet).

Please dont forget to accept this post as a solution to your question !

Hope this helps!

[danilang · Accepted solution]

Hi @Kinetic_analytics 

Here's as close as I can get it, bearing in mind that it remains a static table and can't be pivoted

The split in the middle is to add the totals to the territory rows by creating a new row and then subtracting 0.5 from the RecordID.  This adds the totals and places the rows in the correct spot without the need to process each territory individually.

Dan

[Kinetic_analytics]

Awesome! Thank you. I appreciate your help in my learning process. What a joy! :) 

[Kinetic_analytics]

Thank you. Cool. Appreciate your help. :)