In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Creating pivot in column level in Alteryx

Celeya
6 - Meteoroid

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.

 

 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@Celeya 
There is a Pivot feature in Table tool. Maybe you can check if it suits your requirement.

2024-08-14 130800.png

Celeya
6 - Meteoroid

@qiu Thanks for sharing this .. It works

Qiu
21 - Polaris
21 - Polaris

Happy to be any help.

Labels
Top Solution Authors