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?

[BS_THE_ANALYST]

@TaraA just tweak @ShankerV 's workflow:

[TaraA]

@BS_THE_ANALYST @ShankerV 

So, I changed all to descending but mine still is showing wrong. Maybe it's setting of mine?

[ShankerV]

Hi @TaraA 

Please try this new one.

Expecting this should work in your system.

[TaraA]

@ShankerV 

That worked!!! What did you change? I really appreciate all your help with this.

[ShankerV · Accepted solution]

Hi @TaraA 

The change I did was Enabling this Check box in the Union tool.

So it displayed in order 1 and 2 for your exactly as needed.

Many thanks

Shanker V

[TaraA]

@ShankerV 

Ohh okay, makes sense. Thank you so much for all your help!