How to create a pivot in Alteryx with two rows

[TaraA]

Trying to create a pivot in Alteryx with two different rows but can't seem to get it to work with Summarize/Cross Tab tools, see example pivot below. Anyone have any ideas?

[ShankerV]

Hi @TaraA 

Can you please share the sample data, to check on the pivot possibility.

Many thanks

Shanker V

[TaraA]

Hi @ShankerV 

Here you go and thank you!

[BS_THE_ANALYST]

@TaraA 
The bottom datastream is considering that you may have duplicates:

[TaraA]

Hi @BS_THE_ANALYST 

Thank you, but I was able to create what you have already. What I am looking for is a view with what I have posted above (see original post)....with the Waived By showing underneath the Region.

[ShankerV · Accepted solution]

Hi @TaraA 

Please find the expected output.

Many thanks

Shanker V

[TaraA]

Hi @ShankerV 

This is awesome! Thank you so much. One more question, how did you get yours to sort with JPMA first, see mine below?

[ShankerV]

Hi @TaraA .

Have you ran the same workflow or did any changes in the file.

Wanted to understand why it didn't work in your system and worked correctly in my system.

Edit:

Tried running once more also.

Worked as expected like below.

Many thanks

Shanker V

[TaraA]

Hi @ShankerV

No changes, I just downloaded your workflow and ran it. Did you attach your latest saved version? 

[BS_THE_ANALYST]

@TaraA @ShankerV I think you can sort this issue by sorting the Region Descending in the workflow? Not randomly at the end but throughout the workflow where you selected Region Ascending, change this to Region Descending. Think that should do the trick