SOLVED
Creating pivot in column level in Alteryx
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Celeya
6 - Meteoroid
‎08-13-2024
08:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi. Iam working on a project were one of the reports look like this. (Excel Pivot snip) This has Client Name, project name and Project ID in row level and Sum of week 06/08/2024 and Sum of Week 06/15/2025 in values field where Resources is added in the Column level. I need to replicate the same look in Alteryx. I tried the Transpose and cross tab to get this look, (Alteryx snip) but i expect a view similar to excel pivot.
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
- Developer Tools
- Help
- Transformation
3 REPLIES 3
Qiu
21 - Polaris
‎08-13-2024
09:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Celeya
There is a Pivot feature in Table tool. Maybe you can check if it suits your requirement.
‎08-20-2024
06:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@qiu Thanks for sharing this .. It works
Qiu
21 - Polaris
‎08-20-2024
04:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to be any help.