In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities
here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started.
Learn more here
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Can anyone please help me to replicate Below Excel Pivot table in Alteryx.
You can use the Crosstab tool
The "Rows" in Pivot table are corresponding to the Group by (in your case, tick columns "Country" and "Item")
The "Columns" in Pivot table corresponds to the "change column headers" (in your case, use column "Season")
The computation values in Pivot table correspond to the "Values for new columns" (in your case, use column "Sales" and select "Sum" as the aggregating method".
I highly recommend that you check out the interactive lessons for Excel user https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons which are super useful.
Dawn.
