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?
Hi @TaraA
Please find the expected output.
Many thanks
Shanker V
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.
Can you please share the sample data, to check on the pivot possibility.
Hi @ShankerV
Here you go and thank you!
@TaraA The bottom datastream is considering that you may have duplicates:
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.
This is awesome! Thank you so much. One more question, how did you get yours to sort with JPMA first, see mine below?
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.
No changes, I just downloaded your workflow and ran it. Did you attach your latest saved version?
@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
@TaraA just tweak @ShankerV 's workflow:
@BS_THE_ANALYST @ShankerV
So, I changed all to descending but mine still is showing wrong. Maybe it's setting of mine?
Please try this new one.
Expecting this should work in your system.
@ShankerV
That worked!!! What did you change? I really appreciate all your help with this.
Ohh okay, makes sense. Thank you so much for all your help!
